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 830: pay_payroll_list pay,

826: hr_utility.set_location(l_proc, 130);
827: end if;
828: --
829: l_from_str := ' from per_security_profiles sec,
830: pay_payroll_list pay,
831: per_organization_list org ';
832: --
833: l_cond_str := ' org.security_profile_id = sec.security_profile_id
834: and pay.security_profile_id = sec.security_profile_id

Line 1021: pay_payroll_list pay ';

1017: hr_utility.set_location(l_proc, 190);
1018: end if;
1019: --
1020: l_from_str := ' from per_security_profiles sec,
1021: pay_payroll_list pay ';
1022: --
1023: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
1024: and pay.payroll_id = :l_payroll_id
1025: and sec.view_all_organizations_flag = :l_all

Line 1819: pay_payroll_list pay,

1815: hr_utility.set_location(l_proc, 430);
1816: end if;
1817: --
1818: l_from_str := ' from per_security_profiles sec,
1819: pay_payroll_list pay,
1820: per_position_list posl,
1821: per_organization_list org ';
1822: --
1823: l_cond_str := ' org.security_profile_id = sec.security_profile_id

Line 2052: pay_payroll_list pay,

2048: hr_utility.set_location(l_proc, 490);
2049: end if;
2050: --
2051: l_from_str := ' from per_security_profiles sec,
2052: pay_payroll_list pay,
2053: per_organization_list org ';
2054: --
2055: l_cond_str := ' org.security_profile_id = sec.security_profile_id
2056: and pay.security_profile_id = sec.security_profile_id

Line 2159: pay_payroll_list pay,

2155: hr_utility.set_location(l_proc, 520);
2156: end if;
2157: --
2158: l_from_str := ' from per_security_profiles sec,
2159: pay_payroll_list pay,
2160: per_position_list posl ';
2161: --
2162: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
2163: and pay.security_profile_id = sec.security_profile_id

Line 2472: pay_payroll_list pay ';

2468: hr_utility.set_location(l_proc, 610);
2469: end if;
2470: --
2471: l_from_str := ' from per_security_profiles sec,
2472: pay_payroll_list pay ';
2473: --
2474: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
2475: and pay.payroll_id = :l_payroll_id
2476: and sec.view_all_organizations_flag = :l_all

Line 5706: FROM pay_payroll_list ppl

5702: -- Fetch the payrolls in the static pay list for this profile.
5703: --
5704: CURSOR csr_get_static_pay IS
5705: SELECT ppl.payroll_id
5706: FROM pay_payroll_list ppl
5707: WHERE ppl.security_profile_id IS NOT NULL
5708: AND ppl.security_profile_id = p_security_profile_id;
5709:
5710: BEGIN

Line 8354: DELETE FROM pay_payroll_list ppl

8350: DELETE FROM pay_security_payrolls psp
8351: WHERE psp.business_group_id = p_business_group_id;
8352: hr_utility.set_location(l_proc,30);
8353: --
8354: DELETE FROM pay_payroll_list ppl
8355: WHERE EXISTS ( SELECT ''
8356: FROM pay_payrolls_f pay
8357: WHERE pay.payroll_id = ppl.payroll_id
8358: AND pay.business_group_id = p_business_group_id);

Line 8542: DELETE FROM PAY_PAYROLL_LIST

8538: --
8539: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_PAY_FROM_SECURITY_LIST';
8540: begin
8541: hr_utility.set_location('Entering:'|| l_proc, 10);
8542: DELETE FROM PAY_PAYROLL_LIST
8543: WHERE payroll_id = p_payroll_id;
8544: exception
8545: when NO_DATA_FOUND then
8546: hr_utility.set_location(l_proc, 20);