APPS.HR_SECURITY_INTERNAL dependencies on PAY_PAYROLL_LIST

Line 55: insert into pay_payroll_list (payroll_id, security_profile_id)

51: --
52: -- Insert new payroll into all payroll lists for all profiles which
53: -- Restrict access to payrolls.
54: --
55: insert into pay_payroll_list (payroll_id, security_profile_id)
56: select p_payroll_id, psp.security_profile_id
57: from per_security_profiles psp
58: where psp.view_all_flag <> 'Y'
59: and (( psp.view_all_payrolls_flag <> 'Y'

Line 65: from pay_payroll_list ppl

61: or ( psp.view_all_payrolls_flag <> 'Y'
62: and business_group_id is null))
63: and not exists
64: (select 1
65: from pay_payroll_list ppl
66: where ppl.security_profile_id = psp.security_profile_id
67: and ppl.payroll_id = p_payroll_id);
68:
69: hr_utility.set_location('Leaving:'|| l_proc, 30);

Line 841: pay_payroll_list pay,

837: hr_utility.set_location(l_proc, 130);
838: end if;
839: --
840: l_from_str := ' from per_security_profiles sec,
841: pay_payroll_list pay,
842: per_organization_list org ';
843: --
844: l_cond_str := ' org.security_profile_id = sec.security_profile_id
845: and pay.security_profile_id = sec.security_profile_id

Line 1034: pay_payroll_list pay ';

1030: hr_utility.set_location(l_proc, 190);
1031: end if;
1032: --
1033: l_from_str := ' from per_security_profiles sec,
1034: pay_payroll_list pay ';
1035: --
1036: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
1037: and pay.payroll_id = :l_payroll_id
1038: and sec.view_all_organizations_flag = :l_all

Line 1850: pay_payroll_list pay,

1846: hr_utility.set_location(l_proc, 430);
1847: end if;
1848: --
1849: l_from_str := ' from per_security_profiles sec,
1850: pay_payroll_list pay,
1851: per_position_list posl,
1852: per_organization_list org ';
1853: --
1854: l_cond_str := ' org.security_profile_id = sec.security_profile_id

Line 2085: pay_payroll_list pay,

2081: hr_utility.set_location(l_proc, 490);
2082: end if;
2083: --
2084: l_from_str := ' from per_security_profiles sec,
2085: pay_payroll_list pay,
2086: per_organization_list org ';
2087: --
2088: l_cond_str := ' org.security_profile_id = sec.security_profile_id
2089: and pay.security_profile_id = sec.security_profile_id

Line 2193: pay_payroll_list pay,

2189: hr_utility.set_location(l_proc, 520);
2190: end if;
2191: --
2192: l_from_str := ' from per_security_profiles sec,
2193: pay_payroll_list pay,
2194: per_position_list posl ';
2195: --
2196: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
2197: and pay.security_profile_id = sec.security_profile_id

Line 2509: pay_payroll_list pay ';

2505: hr_utility.set_location(l_proc, 610);
2506: end if;
2507: --
2508: l_from_str := ' from per_security_profiles sec,
2509: pay_payroll_list pay ';
2510: --
2511: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
2512: and pay.payroll_id = :l_payroll_id
2513: and sec.view_all_organizations_flag = :l_all

Line 5950: FROM pay_payroll_list ppl

5946: -- Fetch the payrolls in the static pay list for this profile.
5947: --
5948: CURSOR csr_get_static_pay IS
5949: SELECT ppl.payroll_id
5950: FROM pay_payroll_list ppl
5951: WHERE ppl.security_profile_id IS NOT NULL
5952: AND ppl.security_profile_id = p_security_profile_id;
5953:
5954: BEGIN

Line 9218: DELETE FROM pay_payroll_list ppl

9214: DELETE FROM pay_security_payrolls psp
9215: WHERE psp.business_group_id = p_business_group_id;
9216: hr_utility.set_location(l_proc,30);
9217: --
9218: DELETE FROM pay_payroll_list ppl
9219: WHERE EXISTS ( SELECT ''
9220: FROM pay_payrolls_f pay
9221: WHERE pay.payroll_id = ppl.payroll_id
9222: AND pay.business_group_id = p_business_group_id);

Line 9406: DELETE FROM PAY_PAYROLL_LIST

9402: --
9403: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_PAY_FROM_SECURITY_LIST';
9404: begin
9405: hr_utility.set_location('Entering:'|| l_proc, 10);
9406: DELETE FROM PAY_PAYROLL_LIST
9407: WHERE payroll_id = p_payroll_id;
9408: exception
9409: when NO_DATA_FOUND then
9410: hr_utility.set_location(l_proc, 20);