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_P45_PKG2 dependencies on PER_ASSIGNMENTS

Line 617: from per_assignments pa

613: from per_time_periods ptp1,
614: per_time_periods ptp2
615: where p_act_term_date between ptp1.start_date and ptp1.end_date
616: and ptp1.payroll_id IN (select pa.payroll_id
617: from per_assignments pa
618: where pa.period_of_Service_id = p_period_of_service_id
619: and pa.person_id = p_person_id)
620: and ptp1.regular_payment_date between ptp2.start_date and ptp2.end_date
621: and ptp2.payroll_id IN (select pa2.payroll_id

Line 622: from per_assignments pa2

618: where pa.period_of_Service_id = p_period_of_service_id
619: and pa.person_id = p_person_id)
620: and ptp1.regular_payment_date between ptp2.start_date and ptp2.end_date
621: and ptp2.payroll_id IN (select pa2.payroll_id
622: from per_assignments pa2
623: where pa2.period_of_service_id = p_period_of_Service_id
624: and pa2.person_id = p_person_id);
625: --
626: l_pay_dates get_reg_pay_date_period%ROWTYPE;