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
902: and paf.assignment_type <> 'C'
2152: ben_pl_f pln2,
2153: ben_pgm_f pgm2,
2154: fnd_concurrent_requests fnd,
2155: fnd_concurrent_programs_tl conc,
2156: hr_locations lc,
2157: ben_benfts_grp bnfg
2158: where fnd.request_id = p_concurrent_request_id
2159: and conc.concurrent_program_id = fnd.concurrent_program_id
2160: and conc.application_id = 805