[Home] [Help]
496: ,pay_balance_types pbt
497: ,pay_input_values_f piv
498: ,pay_input_values_f piv1
499: ,pay_input_values_f piv2
500: ,pay_element_types_f pet
501: ,pay_run_results prr
502: ,pay_run_result_values prrv
503: ,pay_run_result_values prrv1
504: WHERE pbf.balance_type_id = pbt.balance_type_id
1103: IS
1104: l_element_type_id number;
1105: BEGIN
1106: select element_type_id into l_element_type_id
1107: from pay_element_types_f
1108: where element_name = p_element_name
1109: and p_effective_date between effective_start_date and effective_end_date
1110: and legislation_code='NL';
1111:
1365: pay_payroll_actions ppa,
1366: pay_assignment_actions paa,
1367: pay_run_results prr,
1368: pay_run_result_values prv,
1369: pay_element_types_f pet,
1370: pay_element_classifications pec,
1371: pay_input_values_f piv
1372: where
1373: paa.payroll_action_id=ppa.payroll_action_id
1410: pay_payroll_actions ppa,
1411: pay_assignment_actions paa,
1412: pay_run_results prr,
1413: pay_run_result_values prv,
1414: pay_element_types_f pet,
1415: pay_element_classifications pec,
1416: pay_sub_classification_rules_f pecs,
1417: pay_input_values_f piv
1418: where
1547: pay_payroll_actions ppa,
1548: pay_assignment_actions paa,
1549: pay_run_results prr,
1550: pay_run_result_values prv,
1551: pay_element_types_f pet,
1552: pay_element_classifications pec,
1553: pay_input_values_f piv
1554: where
1555: paa.payroll_action_id=ppa.payroll_action_id
1702: pay_payroll_actions ppa,
1703: pay_assignment_actions paa,
1704: pay_run_results prr,
1705: pay_run_result_values prv,
1706: pay_element_types_f pet,
1707: pay_element_classifications pec,
1708: pay_sub_classification_rules_f pecs,
1709: pay_input_values_f piv
1710: where
1877: FROM dual
1878: WHERE exists (SELECT 1
1879: FROM pay_object_groups pog
1880: ,pay_element_entries_f peef
1881: ,pay_element_types_f petf
1882: WHERE pog.parent_object_group_id = c_parent_id
1883: AND peef.assignment_id = pog.source_id
1884: AND peef.element_type_id = petf.element_type_id
1885: AND petf.element_name = 'Late Hire Indicator'
2062: FROM dual
2063: WHERE exists (SELECT 1
2064: FROM pay_object_groups pog
2065: ,pay_element_entries_f peef
2066: ,pay_element_types_f petf
2067: WHERE pog.parent_object_group_id = c_parent_id
2068: AND peef.assignment_id = pog.source_id
2069: AND peef.element_type_id = petf.element_type_id
2070: AND petf.element_name = 'Late Hire Indicator'
2292: SELECT 'Y'
2293: FROM dual
2294: WHERE exists (SELECT 1
2295: FROM pay_element_entries_f peef
2296: ,pay_element_types_f petf
2297: WHERE peef.assignment_id = c_ass_id
2298: AND peef.element_type_id = petf.element_type_id
2299: AND petf.element_name = 'Late Hire Indicator'
2300: AND c_eff_date BETWEEN peef.effective_start_date AND peef.effective_end_date
2530: SELECT 'Y'
2531: FROM dual
2532: WHERE exists (SELECT 1
2533: FROM pay_element_entries_f peef
2534: ,pay_element_types_f petf
2535: WHERE peef.assignment_id = c_ass_id
2536: AND peef.element_type_id = petf.element_type_id
2537: AND petf.element_name = 'Late Hire Indicator'
2538: AND c_eff_date BETWEEN peef.effective_start_date AND peef.effective_end_date
2696: and prc.component_name = 'Adjustment'
2697: and prc.legislation_code = 'NL'
2698: and EXISTS
2699: ( select 1
2700: from pay_element_types_f pet
2701: where
2702: pet.business_group_id IS NULL
2703: AND pet.legislation_code = 'NL'
2704: AND peef.element_type_id = pet.element_type_id
2753: from
2754: pay_retro_assignments pra,
2755: pay_retro_entries pre,
2756: pay_element_entries_f peef,
2757: pay_element_types_f petf,
2758: pay_retro_components prc
2759: where
2760: pra.RETRO_ASSIGNMENT_ID = pre.RETRO_ASSIGNMENT_ID
2761: and peef.ELEMENT_ENTRY_ID = pre.ELEMENT_ENTRY_ID
2781: --and modify it to 'Correction-Reprocess-Default' and Delete 'Adjustment-Static'
2782: CURSOR c_ABP_PGGM_Elements
2783: IS
2784: select *
2785: from pay_element_types_f pet
2786: where
2787: pet.business_group_id IS NULL
2788: AND pet.legislation_code = 'NL'
2789: AND (pet.element_name like '%ABP%' OR pet.element_name like '%PGGM%')