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_ALL_PAYROLLS_F

Line 6200: FROM pay_all_payrolls_f pay

6196: -- included.
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

Line 6217: FROM pay_all_payrolls_f pay

6213: -- included.
6214: --
6215: CURSOR csr_get_exclude_pay IS
6216: SELECT pay.payroll_id
6217: FROM pay_all_payrolls_f pay
6218: WHERE p_effective_date BETWEEN
6219: pay.effective_start_date AND pay.effective_end_date
6220: AND pay.business_group_id IS NOT NULL
6221: AND pay.business_group_id = p_business_group_id