eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SECURITY_INTERNAL dependencies on PAY_SECURITY_PAYROLLS

Line 6445: ,pay_security_payrolls psp

6441: --
6442: CURSOR csr_get_include_pay IS
6443: SELECT pay.payroll_id
6444: FROM pay_all_payrolls_f pay
6445: ,pay_security_payrolls psp
6446: WHERE psp.security_profile_id IS NOT NULL
6447: AND psp.security_profile_id = p_security_profile_id
6448: AND psp.payroll_id = pay.payroll_id
6449: AND p_effective_date BETWEEN

Line 6468: FROM pay_security_payrolls psp

6464: AND pay.business_group_id IS NOT NULL
6465: AND pay.business_group_id = p_business_group_id
6466: AND NOT EXISTS
6467: (SELECT NULL
6468: FROM pay_security_payrolls psp
6469: WHERE psp.security_profile_id IS NOT NULL
6470: AND psp.security_profile_id = p_security_profile_id
6471: AND psp.payroll_id = pay.payroll_id);
6472:

Line 9214: DELETE FROM pay_security_payrolls psp

9210: BEGIN
9211: --
9212: hr_utility.set_location(l_proc,20);
9213: --
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