Payroll

 

To Get Tax Calculation card effective date

 select rgi.effective_start_date

  from pay_dir_cards_f dc

,fsion.pay_value_definitions_vl dcd

, pay_dir_card_components_f dcomp

, pay_dir_card_definitions_vl pdccdt

, pay_value_definitions_f pvd

, pay_range_items_f rgi

where 1=1

and dcomp.dir_card_comp_id = :{PARAMETER.FED_CMP_ID}

AND dcd.dir_card_definition_id = dc.dir_card_definition_id

and dcd.base_display_name = 'US_EMPLOYEE_WITHHOLDING_CERTIFICATE'

and dcd.legislation_code = 'US'

and dcomp.dir_card_id = dc.dir_card_id

and sysdate between dcomp.effective_start_date and dcomp.effective_end_date

and pdccdt.dir_card_comp_def_id = dcomp.dir_card_comp_def_id

and pdccdt.base_component_name = 'ORA_HRX_WTH_FEDERAL'

and pdccdt.legislation_code = 'US'

and pvd.source_id = dcomp.dir_card_comp_id

and pvd.source_type = 'PDCC'

and sysdate between pvd.effective_start_date and pvd.effective_end_date

and rgi.value_defn_id = pvd.value_defn_id

and rgi.calc_type_id = pvd.calc_type_id

and sysdate between rgi.effective_start_date and rgi.effective_end_date

and rgi.effective_start_date = (select max(rgi1.effective_start_date)

                                from

                                 Write above query to ge1 max value)

SQL Query to get associated sql query details OF Database Item

select fdi.DEFINITION_TEXT ,fr.text range_or_match From FF_DATABASE_ITEMS fdi user_key_units ,FF_USER_ENTITIES fue user_column_name ,FF_ROUTES fr data_type where fdi.USER_ENTITY_ID = fue.USER_ENTITY_ID user_row_name and fr.ROUTE_ID = fue.ROUTE_ID user_row_name and fdi.USER_NAME = 'ABS_EXT_ACR_BEGIN_BAL'-- DBI NAme user_row_name