DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 849: ,hr_all_organization_units_vl hao

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
851: Where ppf.person_id = p_person_id
852: And ppf.business_group_id = p_business_group_id
853: And ppf.business_group_id = hao.organization_id

Line 897: ,hr_all_organization_units_vl oru

893: ,ppf.payroll_name
894: From per_all_assignments_f paf
895: ,per_assignment_status_types pat
896: ,hr_organization_information ori
897: ,hr_all_organization_units_vl oru
898: ,hr_locations loc
899: ,pay_payrolls_f ppf
900: ,per_assignment_budget_values_f pbv
901: Where paf.person_id = p_person_id

Line 2141: hr_all_organization_units_vl org,

2137: ben_pl_f pln,
2138: ff_formulas_f ff,
2139: ff_formulas_f ff2,
2140: ben_ler_f ler,
2141: hr_all_organization_units_vl org,
2142: ben_rptg_grp_v bnr,
2143: ben_pl_typ_f ptp,
2144: ben_opt_f opt,
2145: ben_eligy_prfl_f elp,