DBA Data[Home] [Help]

APPS.PAY_IE_BIK_CHECK dependencies on PAY_ELEMENT_LINKS_F

Line 21: ,pay_element_links_f pel

17: /*CURSOR c_claim_count_cursor
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

Line 33: ,pay_element_links_f pel

29: CURSOR c_claim_count_cursor
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

Line 77: ,pay_element_links_f pel

73: --Get the claim count for future and current date tracks
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