DBA Data[Home] [Help]

APPS.PAY_ELE_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: from per_business_groups pbg

24: -- Declare cursor
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

Line 90: from per_business_groups pbg

86: -- Declare cursor
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