DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_PERIODS_OF_SERVICE

Line 72: per_periods_of_service pps,

68: ,paf.payroll_id
69: ,'PPG_CODE'
70: ,'PAY_MODE'
71: FROM per_all_assignments_f paf,
72: per_periods_of_service pps,
73: per_assignment_status_types ast
74: WHERE paf.assignment_id = c_assignment_id
75: AND pps.period_of_service_id = paf.period_of_service_id
76: AND ast.assignment_status_type_id = paf.assignment_status_type_id

Line 397: ,per_periods_of_service pps

393: ,pps.date_start
394: ,paf.original_date_of_hire
395: FROM per_all_people_f paf
396: ,per_person_types ppt
397: ,per_periods_of_service pps
398: WHERE paf.person_id = c_person_id
399: AND ppt.person_type_id = paf.person_type_id
400: AND pps.business_group_id = g_business_group_id
401: AND paf.business_group_id = g_business_group_id