[Home] [Help]
410: pay_assignment_actions asa,
411: pay_payroll_actions pya,
412: pay_run_results rrs,
413: pay_run_result_values rrv,
414: pay_element_types_f ele,
415: pay_input_values_f ipv,
416: pay_balance_feeds_f blf,
417: pay_balance_types blt
418: WHERE asa.assignment_id = p_asg_id
454: FROM pay_assignment_actions asa,
455: pay_payroll_actions pya,
456: pay_run_results rrs,
457: pay_run_result_values rrv,
458: pay_element_types_f ele,
459: pay_input_values_f ipv,
460: pay_balance_feeds_f blf,
461: pay_balance_types blt
462: WHERE asa.assignment_id = p_asg_id
494: pay_assignment_actions asa,
495: pay_payroll_actions pya,
496: pay_run_results rrs,
497: pay_run_result_values rrv,
498: pay_element_types_f ele,
499: pay_input_values_f ipv,
500: pay_balance_feeds_f blf,
501: pay_balance_types blt
502: WHERE asa.assignment_id = p_asg_id
538: FROM pay_assignment_actions asa,
539: pay_payroll_actions pya,
540: pay_run_results rrs,
541: pay_run_result_values rrv,
542: pay_element_types_f ele,
543: pay_input_values_f ipv,
544: pay_balance_feeds_f blf,
545: pay_balance_types blt
546: WHERE asa.assignment_id = p_asg_id
687: FROM pay_assignment_actions asa,
688: pay_payroll_actions pya,
689: pay_run_results rrs,
690: pay_run_result_values rrv,
691: pay_element_types_f ele,
692: pay_element_classifications elc,
693: pay_input_values_f ipv,
694: pay_balance_feeds_f blf,
695: pay_balance_types blt
843: FROM pay_assignment_actions asa,
844: pay_payroll_actions pya,
845: pay_run_results rrs,
846: pay_run_result_values rrv,
847: pay_element_types_f ele,
848: pay_element_classifications elc,
849: pay_input_values_f ipv,
850: pay_balance_feeds_f blf,
851: pay_balance_types blt
1003: FROM pay_assignment_actions asa,
1004: pay_payroll_actions pya,
1005: pay_run_results rrs,
1006: pay_run_result_values rrv,
1007: pay_element_types_f ele,
1008: pay_element_classifications elc,
1009: pay_input_values_f ipv,
1010: pay_balance_feeds_f blf,
1011: pay_balance_types blt
1158: FROM pay_assignment_actions asa,
1159: pay_payroll_actions pya,
1160: pay_run_results rrs,
1161: pay_run_result_values rrv,
1162: pay_element_types_f ele,
1163: pay_element_classifications elc,
1164: pay_input_values_f ipv,
1165: pay_balance_feeds_f blf,
1166: pay_balance_types blt
1349: pet.element_information1
1350: from
1351: pay_element_entries_f pee,
1352: pay_element_links_f pel,
1353: pay_element_types_f pet,
1354: pay_element_entry_values_f peev,
1355: pay_input_values_f piv,
1356: pay_retro_component_usages prcu,
1357: pay_element_span_usages pesu,
2251:
2252: /* CURSOR csr_get_element_id (p_dp_or_de VARCHAR2)
2253: IS
2254: SELECT DISTINCT ele.element_type_id
2255: FROM pay_element_types_f ele,
2256: pay_template_core_objects tco1,
2257: pay_shadow_element_types sel,
2258: pay_element_templates etp,
2259: pay_template_core_objects tco2
2266: AND ele.element_type_id = tco1.core_object_id
2267: AND NVL(ele.element_information3,'DP') = p_dp_or_de
2268: UNION ALL
2269: SELECT DISTINCT ele.element_type_id
2270: FROM pay_element_types_f ele,
2271: pay_element_classifications pec
2272: WHERE ele.business_group_id is NULL
2273: AND ele.legislation_code = 'CA'
2274: AND pec.legislation_code = 'CA'
2279: CURSOR csr_get_element_id (p_dp_or_de VARCHAR2) IS
2280: SELECT
2281: pet.element_type_id
2282: FROM
2283: pay_element_types_f pet
2284: WHERE
2285: pet.business_group_id = p_bg_id and
2286: NVL(pet.element_information3,'DP') = p_dp_or_de and
2287: EXISTS
2293: piv.input_value_id = pbf.input_value_id AND
2294: pbf.balance_type_id = l_bal_type_id)
2295: UNION ALL
2296: SELECT DISTINCT ele.element_type_id
2297: FROM pay_element_types_f ele,
2298: pay_element_classifications pec
2299: WHERE ele.business_group_id is NULL
2300: AND ele.legislation_code = 'CA'
2301: AND pec.legislation_code = 'CA'