APPS.HR_TERMINATION_SS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 2996: hr_all_organization_units_tl org,

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,
3000: hr_lookups hrl,

Line 2997: hr_all_organization_units_tl bus,

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,
3000: hr_lookups hrl,
3001: hr_locations_all loc

Line 3127: hr_all_organization_units_tl org ,

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 ,
3129: hr_lookups hrl ,
3130: hr_locations_all loc ,
3131: per_jobs_vl jbs2 ,

Line 3128: hr_all_organization_units_tl bus ,

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 ,
3129: hr_lookups hrl ,
3130: hr_locations_all loc ,
3131: per_jobs_vl jbs2 ,
3132: hr_all_positions_f_tl pos2 ,

Line 3133: Hr_All_Organization_Units_Tl Org2

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')
3136: Or ((Hr_General2.Supervisor_Assignments_In_Use = 'TRUE'
3137: Or p_flow_identifier = 'TERM_SEC_ASGN_FLOW')