APPS.PAY_CN_EXT dependencies on PAY_ELEMENT_LINKS_F

Line 1473: ,pay_element_links_f pil

1469: --
1470: SELECT eev.screen_entry_value
1471: FROM pay_element_entry_values_f eev
1472: ,pay_element_entries_f pee
1473: ,pay_element_links_f pil
1474: ,pay_input_values_f piv
1475: ,pay_element_types_f pet
1476: WHERE pet.element_name = p_element_name
1477: AND pet.element_type_id = piv.element_type_id

Line 1512: ,pay_element_links_f pil

1508: --
1509: SELECT eev.screen_entry_value
1510: FROM pay_element_entry_values_f eev
1511: ,pay_element_entries_f pee
1512: ,pay_element_links_f pil
1513: ,pay_input_values_f piv
1514: ,pay_element_types_f pet
1515: WHERE pet.element_name = p_element_name
1516: AND pet.element_type_id = piv.element_type_id

Line 2859: ,pay_element_links_f pel

2855: IS
2856: --
2857: SELECT COUNT(*)
2858: FROM pay_element_entries_f pee
2859: ,pay_element_links_f pel
2860: ,pay_element_types_f pet
2861: ,per_all_assignments_f paa
2862: WHERE paa.assignment_id = p_assignment_id
2863: AND paa.business_group_id = p_business_group_id

Line 2974: ,pay_element_links_f link

2970: ) IS
2971: SELECT target.ENTRY_INFORMATION1
2972: FROM per_all_assignments_f assign
2973: ,pay_element_entries_f target
2974: ,pay_element_links_f link
2975: ,pay_element_types_f type
2976: WHERE assign.assignment_id = p_assignment_id
2977: AND target.assignment_id = assign.assignment_id
2978: AND target.entry_information_category = 'CN_PHF AND SI INFORMATION'