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_GB_NICAR_06042002 dependencies on PER_ASSIGNMENTS_F

Line 1665: per_assignments_f paf

1661: cursor csr_period_type is
1662: select ptpt.period_type
1663: from per_time_period_types ptpt,
1664: per_time_periods ptp,
1665: per_assignments_f paf
1666: where paf.payroll_id = ptp.payroll_id
1667: and ptpt.period_type = ptp.period_type
1668: and paf.assignment_id = p_assignment_id
1669: and trunc(p_session_date) between trunc(ptp.start_date) and trunc(ptp.end_date);

Line 1676: per_assignments_f paf

1672: cursor csr_next_end_date is
1673: select ptp.end_date
1674: from per_time_periods ptp,
1675: pay_all_payrolls_f papf,
1676: per_assignments_f paf
1677: where paf.payroll_id = papf.payroll_id
1678: and papf.payroll_id = ptp.payroll_id
1679: and paf.assignment_id = p_assignment_id
1680: and ptp.start_date = p_curr_payroll_period_end_date + 1;