APPS.PAY_SPR_BUS dependencies on PAY_SECURITY_PAYROLLS

Line 33: , pay_security_payrolls spr

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;
37: --

Line 106: , pay_security_payrolls spr

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;
110: --

Line 179: ,p_security_profile_id in pay_security_payrolls.security_profile_id%type

175: -- |---------------------------< chk_payroll_id >---------------------------|
176: -- --------------------------------------------------------------------------
177: Procedure chk_payroll_id
178: (p_payroll_id in pay_all_payrolls_f.payroll_id%type
179: ,p_security_profile_id in pay_security_payrolls.security_profile_id%type
180: ,p_business_group_id out nocopy pay_all_payrolls_f.business_group_id%type)
181: --
182: is
183: --

Line 264: FROM pay_security_payrolls spr

260: -- Check that this payroll does not already exist in this security profile.
261: --
262: CURSOR csr_chk_for_dup IS
263: SELECT NULL
264: FROM pay_security_payrolls spr
265: WHERE spr.security_profile_id = p_security_profile_id
266: AND spr.payroll_id = p_payroll_id;
267:
268: BEGIN

Line 413: FROM pay_security_payrolls spr

409: -- Fetches the security payrolls.
410: --
411: CURSOR csr_get_security_payrolls IS
412: SELECT NULL
413: FROM pay_security_payrolls spr
414: WHERE spr.security_profile_id = p_security_profile_id;
415:
416: BEGIN
417: