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_NZBAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 716: from per_time_periods ptp,per_all_assignments_f paa

712:
713: cursor get_next_pay_period_start_date(p_assignment_id in number,
714: p_effective_date in date) is
715: select MIN(ptp.start_date)
716: from per_time_periods ptp,per_all_assignments_f paa
717: where ptp.start_date > p_effective_date
718: and paa.assignment_id = p_assignment_id
719: and paa.payroll_id = ptp.payroll_id;
720:

Line 727: per_all_assignments_f paa

723: cursor get_max_fin_year_end(c_assignment_id in number,
724: c_effective_date in date) is
725: select MAX(ptp.end_date)
726: from per_time_periods ptp,
727: per_all_assignments_f paa
728: where ptp.start_date >= add_months(c_effective_date+1,-12)
729: and ptp.end_date <= c_effective_date
730: and paa.assignment_id = c_assignment_id
731: and paa.payroll_id = ptp.payroll_id;