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_KR_BAL_UPLOAD dependencies on PER_TIME_PERIODS

Line 36: from per_time_periods ptp,

32: --
33: cursor csr_asg_ptd
34: is
35: select nvl(ptp.start_date,g_eot)
36: from per_time_periods ptp,
37: per_assignments_f pa
38: where pa.assignment_id = p_assignment_id
39: and p_upload_date
40: between pa.effective_start_date and pa.effective_end_date

Line 53: from per_time_periods PTP

49: where pa.assignment_id = p_assignment_id
50: and pa.effective_start_date <= p_upload_date
51: and exists (
52: select null
53: from per_time_periods PTP
54: where PTP.payroll_id = pa.payroll_id
55: and pa.effective_start_date between
56: PTP.start_date and PTP.end_date);
57: --

Line 107: FROM per_time_periods ptp, per_assignments_f paf

103: l_expiry_date DATE
104: )
105: IS
106: SELECT MIN(ptp.regular_payment_date)
107: FROM per_time_periods ptp, per_assignments_f paf
108: WHERE paf.assignment_id = l_assignment_id
109: AND l_upload_date BETWEEN paf.effective_start_date
110: AND paf.effective_end_date
111: AND ptp.payroll_id = paf.payroll_id