DBA Data[Home] [Help]

APPS.HR_TERMINATION_SS dependencies on PER_JOBS_VL

Line 2995: per_jobs_vl jbs,

2991: ppf.global_name GLOBAL_NAME,
2992: ppf.npw_number
2993: from per_people_f ppf, -- from secured view for assign new report(bug1855111)
2994: per_Assignments_f2 paf,
2995: per_jobs_vl jbs,
2996: hr_all_organization_units_tl org,
2997: hr_all_organization_units_tl bus,
2998: hr_all_positions_f_vl pos,
2999: per_grades_vl pg,

Line 3124: per_jobs_vl jbs ,

3120: FROM per_all_people_f ppf, -- Changed to use base table, see bug 2130066
3121: per_all_people_f ppf2 ,
3122: per_all_assignments_f paf ,
3123: per_all_assignments_f paf2 ,
3124: per_jobs_vl jbs ,
3125: hr_all_positions_f_tl pos ,
3126: per_grades_vl pg ,
3127: hr_all_organization_units_tl org ,
3128: hr_all_organization_units_tl bus ,

Line 3131: per_jobs_vl jbs2 ,

3127: hr_all_organization_units_tl org ,
3128: hr_all_organization_units_tl bus ,
3129: hr_lookups hrl ,
3130: hr_locations_all loc ,
3131: per_jobs_vl jbs2 ,
3132: hr_all_positions_f_tl pos2 ,
3133: Hr_All_Organization_Units_Tl Org2
3134: Where Paf.Supervisor_Id = p_old_sup_person_id
3135: AND ((p_flow_identifier = 'TERMINATION_FLOW')