APPS.PAY_IN_TERMINATION_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 769: FROM pay_element_links_f pel,

765: CURSOR c_element_link
766: IS
767: SELECT pel.element_link_id
768: ,pet.element_type_id
769: FROM pay_element_links_f pel,
770: pay_element_types_f pet,
771: per_assignments_f paf
772: WHERE pet.element_name = p_element_name
773: AND paf.assignment_id = g_assignment_id

Line 893: l_element_link_id pay_element_links_f.element_link_id%TYPE;

889: )
890: IS
891: l_procedure VARCHAR2(100) ;
892: l_element_type_id pay_element_types_f.element_type_id%TYPE;
893: l_element_link_id pay_element_links_f.element_link_id%TYPE;
894: l_input_values t_input_values_tab;
895: l_expected_entries NUMBER;
896: l_effective_start_date DATE;
897: l_effective_end_date DATE;

Line 1054: FROM pay_element_links_f pel,

1050: CURSOR csr_element_link (l_business_group_id IN NUMBER,
1051: l_payroll_id IN NUMBER)
1052: IS
1053: SELECT pel.element_link_id
1054: FROM pay_element_links_f pel,
1055: pay_element_types_f pet
1056: WHERE pet.element_name = p_element_name
1057: AND pet.element_type_id = pel.element_type_id
1058: AND (pel.payroll_id = l_payroll_id

Line 1185: FROM pay_element_links_f pel,

1181: CURSOR csr_element_link (l_business_group_id IN NUMBER,
1182: l_payroll_id IN NUMBER)
1183: IS
1184: SELECT pel.element_link_id
1185: FROM pay_element_links_f pel,
1186: pay_element_types_f pet
1187: WHERE pet.element_name = p_element_name
1188: AND pet.element_type_id = pel.element_type_id
1189: AND (pel.payroll_id = l_payroll_id