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_GB_TP_PENSION_EXTRACTS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 223: -- FROM pqp_assignment_attributes_f eaat -- effective aat

219: -- ,NULL) prev_tp_safeguarded_grade
220: -- ,DECODE(SIGN(paat.effective_end_date - eaat.effective_start_date)
221: -- ,-1,paat.tp_elected_pension
222: -- ,NULL) prev_tp_elected_pension
223: -- FROM pqp_assignment_attributes_f eaat -- effective aat
224: -- ,pqp_assignment_attributes_f paat -- previous aat
225: -- WHERE eaat.assignment_id = p_assignment_id
226: -- AND p_effective_date
227: -- BETWEEN eaat.effective_start_date

Line 224: -- ,pqp_assignment_attributes_f paat -- previous aat

220: -- ,DECODE(SIGN(paat.effective_end_date - eaat.effective_start_date)
221: -- ,-1,paat.tp_elected_pension
222: -- ,NULL) prev_tp_elected_pension
223: -- FROM pqp_assignment_attributes_f eaat -- effective aat
224: -- ,pqp_assignment_attributes_f paat -- previous aat
225: -- WHERE eaat.assignment_id = p_assignment_id
226: -- AND p_effective_date
227: -- BETWEEN eaat.effective_start_date
228: -- AND eaat.effective_end_date

Line 254: FROM pqp_assignment_attributes_f eaat -- effective aat

250: ,eaat.tp_elected_pension tp_elected_pension
251: ,eaat.creation_date creation_date
252: -- Added for salary scale changes
253: ,eaat.tp_safeguarded_spinal_point_id tp_sf_spinal_point_id
254: FROM pqp_assignment_attributes_f eaat -- effective aat
255: WHERE eaat.assignment_id = p_assignment_id
256: AND ( -- retrieve the effective row
257: (NVL(p_effective_date,g_effective_date)
258: BETWEEN eaat.effective_start_date

Line 285: FROM pqp_assignment_attributes_f eaat -- effective aat

281: ,eaat.tp_elected_pension tp_elected_pension
282: ,eaat.creation_date creation_date
283: -- Added for salary scale changes
284: ,eaat.tp_safeguarded_spinal_point_id tp_sf_spinal_point_id
285: FROM pqp_assignment_attributes_f eaat -- effective aat
286: WHERE eaat.assignment_id = p_assignment_id
287: AND ( -- retrieve the effective row
288: (NVL(p_effective_date,g_effective_date)
289: BETWEEN eaat.effective_start_date