APPS.PJI_PMV_UTIL dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 103: per_org_structure_elements orgd

99: IF l_top_organization_id = 0 THEN
100: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
101: (SELECT orgd.organization_id_child
102: FROM
103: per_org_structure_elements orgd
104: , pji_system_settings pset
105: , hr_all_organization_units org
106: WHERE 1=1
107: AND orgd.org_structure_version_id = pset.org_structure_version_id

Line 117: per_org_structure_elements orgd

113:
114: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
115: (SELECT orgd.organization_id_child
116: FROM
117: per_org_structure_elements orgd
118: , pji_system_settings pset
119: , per_organization_list sec
120: , hr_all_organization_units org
121: WHERE 1=1

Line 134: per_org_structure_elements orgd

130:
131: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
132: (SELECT orgd.organization_id_child
133: FROM
134: per_org_structure_elements orgd
135: , pji_system_settings pset
136: , hr_all_organization_units org
137: WHERE 1=1
138: AND orgd.org_structure_version_id = pset.org_structure_version_id

Line 162: per_org_structure_elements p

158: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
159: (SELECT orgd.organization_id_child
160: FROM
161: (select distinct organization_id_parent organization_id_child, NULL organization_id_parent from
162: per_org_structure_elements p
163: , pji_system_settings pset
164: where p.org_structure_version_id = pset.org_structure_version_id
165: and not exists
166: (select 1 from

Line 167: per_org_structure_elements c

163: , pji_system_settings pset
164: where p.org_structure_version_id = pset.org_structure_version_id
165: and not exists
166: (select 1 from
167: per_org_structure_elements c
168: where c.organization_id_child = p.organization_id_parent
169: and c.org_structure_version_id = p.org_structure_version_id)) orgd
170: , per_organization_list sec
171: , hr_all_organization_units org