DBA Data[Home] [Help]

APPS.PJI_PMV_UTIL dependencies on PJI_SYSTEM_SETTINGS

Line 104: , pji_system_settings pset

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
108: AND orgd.organization_id_child = org.organization_id

Line 118: , pji_system_settings pset

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
122: AND orgd.org_structure_version_id = pset.org_structure_version_id

Line 135: , pji_system_settings pset

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
139: AND orgd.organization_id_child = org.organization_id

Line 163: , pji_system_settings pset

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
167: per_org_structure_elements c