DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on PER_ALL_PEOPLE_F

Line 850: From per_all_people_f ppf

846: ,pps.adjusted_svc_date
847: ,pad.postal_code
848: ,ppf.national_identifier
849: ,hao.name
850: From per_all_people_f ppf
851: ,per_periods_of_service pps
852: ,per_addresses pad
853: ,hr_all_organization_units_vl hao
854: ,ben_benfts_grp bng

Line 974: from per_all_people_f ppf

970: ;
971: --
972: cursor c_total_fte is
973: select sum(pab.value)
974: from per_all_people_f ppf
975: ,per_all_assignments_f paf
976: ,per_assignment_budget_values_f pab
977: where ppf.person_id = p_person_id
978: and paf.assignment_type <> 'C'