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 6444: FROM pay_all_payrolls_f pay

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

Line 6461: FROM pay_all_payrolls_f pay

6457: -- included.
6458: --
6459: CURSOR csr_get_exclude_pay IS
6460: SELECT pay.payroll_id
6461: FROM pay_all_payrolls_f pay
6462: WHERE p_effective_date BETWEEN
6463: pay.effective_start_date AND pay.effective_end_date
6464: AND pay.business_group_id IS NOT NULL
6465: AND pay.business_group_id = p_business_group_id