APPS.PA_PAXRWDOH_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 110: p_from_clause := 'hr_organization_information hr2,PER_ORG_STRUCTURE_VERSIONS posv';

106: p_where_clause1 := 'and pi.business_group_id = hr2.organization_id';
107: P_structure_id := 'and p.org_structure_version_id = posv.org_structure_version_id';
108: P_version_id := 'and pos1.organization_structure_id = posv.organization_structure_id';
109: P_org_hr := 'and p.organization_id_parent= org.organization_id';
110: p_from_clause := 'hr_organization_information hr2,PER_ORG_STRUCTURE_VERSIONS posv';
111: P_Decode_column := 'to_number(hr2.org_information2)';
112: P_select_column1 := 'p.organization_id_parent';
113: p_parent_org_id :='p.organization_id_parent';
114: p_burden:= 'and hr2.org_information_context ' ||'='||''''||'Project Burdening Hierarchy'||'''';

Line 125: ,hr_organization_information c

121:
122: select distinct organization_id_parent into start_org_id
123: from per_org_structure_elements a
124: ,pa_implementations b
125: ,hr_organization_information c
126: where organization_id_parent not in
127: ( select d.ORGANIZATION_ID_CHILD from per_org_structure_elements d
128: where d.org_structure_version_id = to_number(c.org_information2)
129: )