DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on PER_PERIODS_OF_SERVICE

Line 63: per_periods_of_service pps,

59: ,paf.normal_hours
60: ,pps.date_start
61: ,pps.actual_termination_date
62: FROM per_all_assignments_f paf,
63: per_periods_of_service pps,
64: per_assignment_status_types ast
65: WHERE paf.assignment_id = c_assignment_id
66: AND pps.period_of_service_id(+) = paf.period_of_service_id
67: AND ast.assignment_status_type_id = paf.assignment_status_type_id

Line 322: ,per_periods_of_service pps

318: ,pps.date_start
319: ,paf.original_date_of_hire
320: FROM per_all_people_f paf
321: ,per_person_types ppt
322: ,per_periods_of_service pps
323: WHERE paf.person_id = c_person_id
324: AND ppt.person_type_id = paf.person_type_id
325: AND pps.business_group_id = g_business_group_id
326: AND paf.business_group_id = g_business_group_id