DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on PER_ALL_PEOPLE_F

Line 846: From per_all_people_f ppf

842: ,pps.adjusted_svc_date
843: ,pad.postal_code
844: ,ppf.national_identifier
845: ,hao.name
846: From per_all_people_f ppf
847: ,per_periods_of_service pps
848: ,per_addresses pad
849: ,hr_all_organization_units_vl hao
850: ,ben_benfts_grp bng

Line 970: from per_all_people_f ppf

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