DBA Data[Home] [Help]

APPS.PAY_SPR_BUS dependencies on PER_BUSINESS_GROUPS

Line 32: from per_business_groups pbg

28: -- Declare cursor
29: --
30: cursor csr_sec_grp is
31: select pbg.security_group_id
32: from per_business_groups pbg
33: , pay_security_payrolls spr
34: where spr.security_profile_id = p_security_profile_id
35: and spr.payroll_id = p_payroll_id
36: and pbg.business_group_id = spr.business_group_id;

Line 105: from per_business_groups pbg

101: -- Declare cursor
102: --
103: cursor csr_leg_code is
104: select pbg.legislation_code
105: from per_business_groups pbg
106: , pay_security_payrolls spr
107: where spr.security_profile_id = p_security_profile_id
108: and spr.payroll_id = p_payroll_id
109: and pbg.business_group_id = spr.business_group_id;