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.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_TIME_PERIODS

Line 260: FROM per_time_periods PTP

256: ,c_assignment_id IN NUMBER
257: ,c_date_earned IN DATE )
258: IS
259: SELECT NVL(min(PTP.start_date),to_date('0101'||c_year,'DDMMYYYY'))
260: FROM per_time_periods PTP
261: ,per_all_assignments_f PAA
262: WHERE PAA.assignment_id = c_assignment_id
263: AND PTP.payroll_id = PAA.payroll_id
264: AND (c_date_earned between PAA.effective_start_date and PAA.effective_end_date)

Line 276: FROM per_time_periods PTP

272: ,c_assignment_id IN NUMBER
273: ,c_date_earned IN DATE )
274: IS
275: SELECT NVL(max(PTP.end_date),to_date('3112'||c_year,'DDMMYYYY'))
276: FROM per_time_periods PTP
277: , per_all_assignments_f PAA
278: WHERE PAA.assignment_id = c_assignment_id
279: AND PTP.payroll_id = PAA.payroll_id
280: AND (c_date_earned between PAA.effective_start_date and PAA.effective_end_date)

Line 291: , per_time_periods TPERIOD

287: CURSOR c_get_num_periods_per_year(c_assignment_id IN NUMBER
288: ,c_date_earned IN DATE) IS
289: SELECT NVL(TPTYPE.number_per_fiscal_year,12)
290: FROM per_all_assignments_f PAA
291: , per_time_periods TPERIOD
292: , per_time_period_types TPTYPE
293: WHERE PAA.assignment_id = c_assignment_id
294: AND TPERIOD.payroll_id = PAA.payroll_id
295: AND ( c_date_earned between PAA.effective_start_date and PAA.effective_end_date)

Line 453: FROM per_time_periods PTP

449: trunc( to_number(PTP.period_num)/10),
450: 0,substr(PTP.period_name,3,4),
451: 1,substr(PTP.period_name,4,4)
452: )
453: FROM per_time_periods PTP
454: ,per_all_assignments_f PAA
455: WHERE PAA.assignment_id = c_assignment_id
456: AND PTP.payroll_id = PAA.payroll_id
457: AND ( c_effective_date between PTP.start_date and PTP.end_date );

Line 7128: ,per_time_periods TPERIOD

7124: ,c_date_earned IN DATE
7125: ) IS
7126: SELECT NVL(period_num,0)
7127: FROM per_all_assignments_f PAA
7128: ,per_time_periods TPERIOD
7129: WHERE
7130: PAA.assignment_id = c_assignment_id
7131: AND TPERIOD.payroll_id = PAA.payroll_id
7132: AND c_date_earned between PAA.effective_start_date and PAA.effective_end_date