DBA Data[Home] [Help]

APPS.PAY_IE_BIK_CHECK dependencies on PAY_ELEMENT_ENTRIES_F

Line 22: ,pay_element_entries_f pee

18: IS
19: SELECT count(*)
20: FROM pay_element_types_f pet
21: ,pay_element_links_f pel
22: ,pay_element_entries_f pee
23: WHERE pel.element_type_id =pet.element_type_id
24: AND pee.assignment_id = p_assignment_id
25: AND pel.element_link_id = pee.element_link_id
26: AND pet.legislation_code = 'IE'

Line 34: ,pay_element_entries_f pee

30: IS
31: SELECT count(*)
32: FROM pay_element_types_f pet
33: ,pay_element_links_f pel
34: ,pay_element_entries_f pee
35: ,pay_input_values_f piv
36: ,pay_element_entry_values_f peev
37: WHERE pel.element_type_id =pet.element_type_id
38: AND pee.assignment_id = p_assignment_id

Line 78: ,pay_element_entries_f pee

74: CURSOR c_claim_count_cursor IS
75: SELECT count(*)
76: FROM pay_element_types_f pet
77: ,pay_element_links_f pel
78: ,pay_element_entries_f pee
79: WHERE pel.element_type_id =pet.element_type_id
80: AND pee.assignment_id = p_assignment_id
81: AND pel.element_link_id = pee.element_link_id
82: AND pet.legislation_code = 'IE'