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.PAY_MX_PAYROLL_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 3878: FROM per_all_assignments_f paf

3874: ) IS
3875: SELECT /*+ INDEX(paf PER_ASSIGNMENTS_F_N7)*/
3876: DISTINCT paf.organization_id,
3877: paf.business_group_id
3878: FROM per_all_assignments_f paf
3879: WHERE paf.payroll_id = cp_payroll_id
3880: AND cp_effective_date BETWEEN paf.effective_start_date
3881: AND paf.effective_end_date;
3882:

Line 3886: FROM per_all_assignments_f paf,

3882:
3883: CURSOR c_get_legal_ER IS
3884: SELECT DISTINCT hr_mx_utility.get_legal_employer(paf.business_group_id,
3885: paa.tax_unit_id)
3886: FROM per_all_assignments_f paf,
3887: pay_assignment_actions paa
3888: WHERE paa.payroll_action_id = p_payroll_action_id
3889: AND paa.assignment_id = paf.assignment_id
3890: AND paf.payroll_id = p_payroll_id