DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 853: ,hr_all_organization_units_vl hao

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
855: Where ppf.person_id = p_person_id
856: And ppf.business_group_id = p_business_group_id
857: And ppf.business_group_id = hao.organization_id

Line 901: ,hr_all_organization_units_vl oru

897: ,ppf.payroll_name
898: From per_all_assignments_f paf
899: ,per_assignment_status_types pat
900: ,hr_organization_information ori
901: ,hr_all_organization_units_vl oru
902: ,hr_locations loc
903: ,pay_payrolls_f ppf
904: ,per_assignment_budget_values_f pbv
905: Where paf.person_id = p_person_id

Line 2151: hr_all_organization_units_vl org,

2147: ben_pl_f pln,
2148: ff_formulas_f ff,
2149: ff_formulas_f ff2,
2150: ben_ler_f ler,
2151: hr_all_organization_units_vl org,
2152: ben_rptg_grp_v bnr,
2153: ben_pl_typ_f ptp,
2154: ben_opt_f opt,
2155: ben_eligy_prfl_f elp,