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_SERVICE_HISTORY_CALC_PKG dependencies on PQP_SERVICE_HISTORY_PERIODS

Line 62: AND not exists (SELECT 1 FROM pqp_service_history_periods shp

58: WHERE pps.period_of_service_id = asg.period_of_service_id
59: AND trunc(p_calculation_date) BETWEEN trunc(asg.effective_start_date)
60: AND trunc(asg.effective_end_date)
61: AND asg.assignment_id = p_assignment_id
62: AND not exists (SELECT 1 FROM pqp_service_history_periods shp
63: WHERE trunc(pps.date_start) BETWEEN trunc(shp.start_date)
64: AND trunc(shp.end_date)
65: AND shp.assignment_id = p_assignment_id
66: AND shp.continuous_service = NVL(p_continuous_service, shp.continuous_service));

Line 248: FROM pqp_service_history_periods shp1

244: ,DECODE(LEAST(trunc(end_date), trunc(p_calculation_date)), trunc(end_date),
245: period_years, NULL) period_years
246: ,DECODE(LEAST(trunc(end_date), trunc(p_calculation_date)), trunc(end_date),
247: period_days, NULL) period_days
248: FROM pqp_service_history_periods shp1
249: WHERE shp1.assignment_id = p_assignment_id
250: AND trunc(shp1.start_date) <= trunc(p_calculation_date)
251: AND not exists (SELECT 1 FROM pqp_service_history_periods shp2
252: WHERE shp2.assignment_id = shp1.assignment_id

Line 251: AND not exists (SELECT 1 FROM pqp_service_history_periods shp2

247: period_days, NULL) period_days
248: FROM pqp_service_history_periods shp1
249: WHERE shp1.assignment_id = p_assignment_id
250: AND trunc(shp1.start_date) <= trunc(p_calculation_date)
251: AND not exists (SELECT 1 FROM pqp_service_history_periods shp2
252: WHERE shp2.assignment_id = shp1.assignment_id
253: AND shp2.service_history_period_id <> shp1.service_history_period_id
254: AND (trunc(shp2.start_date) between trunc(shp1.start_date)
255: and trunc(shp1.end_date)

Line 266: FROM pqp_service_history_periods shp1

262: --
263: CURSOR c_overlap_serv IS
264: SELECT MIN(shp1.start_date) start_date
265: ,LEAST(trunc(MAX(shp1.end_date)),trunc(p_calculation_date)) end_date
266: FROM pqp_service_history_periods shp1
267: WHERE shp1.assignment_id = p_assignment_id
268: AND trunc(shp1.start_date) <= trunc(p_calculation_date)
269: AND exists (SELECT 1 FROM pqp_service_history_periods shp2
270: WHERE shp2.assignment_id = shp1.assignment_id

Line 269: AND exists (SELECT 1 FROM pqp_service_history_periods shp2

265: ,LEAST(trunc(MAX(shp1.end_date)),trunc(p_calculation_date)) end_date
266: FROM pqp_service_history_periods shp1
267: WHERE shp1.assignment_id = p_assignment_id
268: AND trunc(shp1.start_date) <= trunc(p_calculation_date)
269: AND exists (SELECT 1 FROM pqp_service_history_periods shp2
270: WHERE shp2.assignment_id = shp1.assignment_id
271: AND shp2.service_history_period_id <> shp1.service_history_period_id
272: AND (trunc(shp2.start_date) between trunc(shp1.start_date)
273: and trunc(shp1.end_date)

Line 374: FROM pqp_service_history_periods shp1

370: SELECT start_date
371: ,end_date
372: ,period_years
373: ,period_days
374: FROM pqp_service_history_periods shp1
375: WHERE shp1.assignment_id = p_assignment_id;
376: --
377: l_func VARCHAR2(80) := 'pqp_service_history_calc_pkg.calculate_all_service_history';
378: l_days NUMBER(12);

Line 458: FROM pqp_service_history_periods shp1

454: ,DECODE(LEAST(trunc(end_date), trunc(p_calculation_date)), trunc(end_date),
455: period_years, NULL) period_years
456: ,DECODE(LEAST(trunc(end_date), trunc(p_calculation_date)), trunc(end_date),
457: period_days, NULL) period_days
458: FROM pqp_service_history_periods shp1
459: WHERE shp1.assignment_id = p_assignment_id
460: AND trunc(shp1.start_date) <= trunc(p_calculation_date)
461: AND shp1.continuous_service = 'Y'
462: AND not exists (SELECT 1 FROM pqp_service_history_periods shp2

Line 462: AND not exists (SELECT 1 FROM pqp_service_history_periods shp2

458: FROM pqp_service_history_periods shp1
459: WHERE shp1.assignment_id = p_assignment_id
460: AND trunc(shp1.start_date) <= trunc(p_calculation_date)
461: AND shp1.continuous_service = 'Y'
462: AND not exists (SELECT 1 FROM pqp_service_history_periods shp2
463: WHERE shp2.assignment_id = shp1.assignment_id
464: AND shp2.continuous_service = 'Y'
465: AND shp2.service_history_period_id <> shp1.service_history_period_id
466: AND (trunc(shp2.start_date) between trunc(shp1.start_date)

Line 478: FROM pqp_service_history_periods shp1

474: --
475: CURSOR c_cont_overlap_serv IS
476: SELECT MIN(shp1.start_date) start_date
477: ,LEAST(trunc(MAX(shp1.end_date)), trunc(p_calculation_date)) end_date
478: FROM pqp_service_history_periods shp1
479: WHERE shp1.assignment_id = p_assignment_id
480: AND trunc(shp1.start_date) <= trunc(p_calculation_date)
481: AND shp1.continuous_service = 'Y'
482: AND exists (SELECT 1 FROM pqp_service_history_periods shp2

Line 482: AND exists (SELECT 1 FROM pqp_service_history_periods shp2

478: FROM pqp_service_history_periods shp1
479: WHERE shp1.assignment_id = p_assignment_id
480: AND trunc(shp1.start_date) <= trunc(p_calculation_date)
481: AND shp1.continuous_service = 'Y'
482: AND exists (SELECT 1 FROM pqp_service_history_periods shp2
483: WHERE shp2.assignment_id = shp1.assignment_id
484: AND shp2.continuous_service = 'Y'
485: AND shp2.service_history_period_id <> shp1.service_history_period_id
486: AND (trunc(shp2.start_date) between trunc(shp1.start_date)

Line 584: FROM pqp_service_history_periods shp1

580: SELECT start_date
581: ,end_date
582: ,period_years
583: ,period_days
584: FROM pqp_service_history_periods shp1
585: WHERE shp1.assignment_id = p_assignment_id
586: AND shp1.continuous_service = 'Y';
587: --
588: l_func VARCHAR2(80) := 'pqp_service_history_calc_pkg.calculate_all_continuous_serv';