[Home] [Help]
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
902: and paf.assignment_type <> 'C'
903: and paf.primary_flag = 'Y'
2143: ben_pl_typ_f ptp,
2144: ben_opt_f opt,
2145: ben_eligy_prfl_f elp,
2146: ben_vrbl_rt_prfl_f vpf,
2147: pay_payrolls_f pay,
2148: ben_pstl_zip_rng_f rzr,
2149: hr_tax_units_v tax,
2150: ben_popl_enrt_typ_cycl_f pop,
2151: ben_enrt_perd epo,