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.

[Home] [Help]

APPS.HR_SECURITY_INTERNAL dependencies on PAY_SECURITY_PAYROLLS

Line 6201: ,pay_security_payrolls psp

6197: --
6198: CURSOR csr_get_include_pay IS
6199: SELECT pay.payroll_id
6200: FROM pay_all_payrolls_f pay
6201: ,pay_security_payrolls psp
6202: WHERE psp.security_profile_id IS NOT NULL
6203: AND psp.security_profile_id = p_security_profile_id
6204: AND psp.payroll_id = pay.payroll_id
6205: AND p_effective_date BETWEEN

Line 6224: FROM pay_security_payrolls psp

6220: AND pay.business_group_id IS NOT NULL
6221: AND pay.business_group_id = p_business_group_id
6222: AND NOT EXISTS
6223: (SELECT NULL
6224: FROM pay_security_payrolls psp
6225: WHERE psp.security_profile_id IS NOT NULL
6226: AND psp.security_profile_id = p_security_profile_id
6227: AND psp.payroll_id = pay.payroll_id);
6228:

Line 8350: DELETE FROM pay_security_payrolls psp

8346: BEGIN
8347: --
8348: hr_utility.set_location(l_proc,20);
8349: --
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