APPS.PAY_CN_EXT dependencies on PAY_ELEMENT_ENTRIES_F

Line 1472: ,pay_element_entries_f pee

1468: IS
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

Line 1511: ,pay_element_entries_f pee

1507: IS
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

Line 2858: FROM pay_element_entries_f pee

2854: ,p_element_name IN VARCHAR2)
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

Line 2973: ,pay_element_entries_f target

2969: , p_date_earned IN DATE
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

Line 2992: l_entry_information1 pay_element_entries_f.entry_information1%TYPE;

2988: AND p_date_earned BETWEEN type.effective_start_date
2989: AND type.effective_end_date;
2990:
2991:
2992: l_entry_information1 pay_element_entries_f.entry_information1%TYPE;
2993:
2994: --
2995: BEGIN
2996: --