DBA Data[Home] [Help]

APPS.PAY_IE_BIK_CHECK dependencies on PAY_ELEMENT_TYPES_F

Line 20: FROM pay_element_types_f pet

16: -- Bug 3466513 Changed the cursor to get the count based on vehicle allocation id
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

Line 32: FROM pay_element_types_f pet

28:
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

Line 76: FROM pay_element_types_f pet

72: ) RETURN NUMBER IS
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