DBA Data[Home] [Help]

APPS.PAY_ELE_BUS dependencies on PAY_ELEMENT_ENTRIES_F

Line 29: , pay_element_entries_f ele

25: --
26: cursor csr_sec_grp is
27: select distinct pbg.security_group_id
28: from per_business_groups pbg
29: , pay_element_entries_f ele
30: , per_all_assignments_f paa
31: where ele.element_entry_id = p_element_entry_id
32: and pbg.business_group_id = paa.business_group_id
33: and paa.assignment_id = ele.assignment_id;

Line 91: , pay_element_entries_f ele

87: --
88: cursor csr_leg_code is
89: select distinct pbg.legislation_code
90: from per_business_groups pbg
91: , pay_element_entries_f ele
92: , per_all_assignments_f paa
93: where ele.element_entry_id = p_element_entry_id
94: and pbg.business_group_id = paa.business_group_id
95: and paa.assignment_id = ele.assignment_id;

Line 297: -- element_type_id on pay_element_entries_f.

293: --
294: -- Description:
295: -- This function derives the element_type_id from the element_link_id, the
296: -- resulting element_type_id will be used to populate the denormalised column,
297: -- element_type_id on pay_element_entries_f.
298: --
299: -- Pre Conditions:
300: -- None
301: --

Line 308: -- the element_type_id on pay_element_entries_f.

304: -- p_effective_date date
305: --
306: -- Post Success:
307: -- The corresponding element_type_id will be returned, and used to populate
308: -- the element_type_id on pay_element_entries_f.
309: --
310: -- Post Failure:
311: -- None
312: --