APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 414: pay_element_types_f ele,

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

Line 458: pay_element_types_f ele,

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

Line 498: pay_element_types_f ele,

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

Line 542: pay_element_types_f ele,

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

Line 690: pay_element_types_f ele,

686: FROM pay_assignment_actions asa,
687: pay_payroll_actions pya,
688: pay_run_results rrs,
689: pay_run_result_values rrv,
690: pay_element_types_f ele,
691: pay_element_classifications elc,
692: pay_input_values_f ipv,
693: pay_balance_feeds_f blf,
694: pay_balance_types blt

Line 846: pay_element_types_f ele,

842: FROM pay_assignment_actions asa,
843: pay_payroll_actions pya,
844: pay_run_results rrs,
845: pay_run_result_values rrv,
846: pay_element_types_f ele,
847: pay_element_classifications elc,
848: pay_input_values_f ipv,
849: pay_balance_feeds_f blf,
850: pay_balance_types blt

Line 1002: pay_element_types_f ele,

998: FROM pay_assignment_actions asa,
999: pay_payroll_actions pya,
1000: pay_run_results rrs,
1001: pay_run_result_values rrv,
1002: pay_element_types_f ele,
1003: pay_element_classifications elc,
1004: pay_input_values_f ipv,
1005: pay_balance_feeds_f blf,
1006: pay_balance_types blt

Line 1193: pay_element_types_f pet,

1189: pet.element_information1
1190: from
1191: pay_element_entries_f pee,
1192: pay_element_links_f pel,
1193: pay_element_types_f pet,
1194: pay_element_entry_values_f peev,
1195: pay_input_values_f piv,
1196: pay_retro_component_usages prcu,
1197: pay_element_span_usages pesu,

Line 1992: FROM pay_element_types_f ele,

1988:
1989: /* CURSOR csr_get_element_id (p_dp_or_de VARCHAR2)
1990: IS
1991: SELECT DISTINCT ele.element_type_id
1992: FROM pay_element_types_f ele,
1993: pay_template_core_objects tco1,
1994: pay_shadow_element_types sel,
1995: pay_element_templates etp,
1996: pay_template_core_objects tco2

Line 2007: FROM pay_element_types_f ele,

2003: AND ele.element_type_id = tco1.core_object_id
2004: AND NVL(ele.element_information3,'DP') = p_dp_or_de
2005: UNION ALL
2006: SELECT DISTINCT ele.element_type_id
2007: FROM pay_element_types_f ele,
2008: pay_element_classifications pec
2009: WHERE ele.business_group_id is NULL
2010: AND ele.legislation_code = 'CA'
2011: AND pec.legislation_code = 'CA'

Line 2020: pay_element_types_f pet

2016: CURSOR csr_get_element_id (p_dp_or_de VARCHAR2) IS
2017: SELECT
2018: pet.element_type_id
2019: FROM
2020: pay_element_types_f pet
2021: WHERE
2022: pet.business_group_id = p_bg_id and
2023: NVL(pet.element_information3,'DP') = p_dp_or_de and
2024: EXISTS

Line 2034: FROM pay_element_types_f ele,

2030: piv.input_value_id = pbf.input_value_id AND
2031: pbf.balance_type_id = l_bal_type_id)
2032: UNION ALL
2033: SELECT DISTINCT ele.element_type_id
2034: FROM pay_element_types_f ele,
2035: pay_element_classifications pec
2036: WHERE ele.business_group_id is NULL
2037: AND ele.legislation_code = 'CA'
2038: AND pec.legislation_code = 'CA'