APPS.PJI_PMV_UTIL dependencies on DUAL

Line 100: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS

96: x_insert_top_org_flag => l_insert_top_org_flag);
97:
98: BEGIN
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

Line 114: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS

110:
111: RETURN l_org_id;
112: ELSIF l_user_assmt_flag = 'N' THEN
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

Line 131: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS

127:
128: RETURN l_org_id;
129: ELSIF l_user_assmt_flag = 'Y' THEN
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

Line 158: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS

154:
155: --Bug 4599990.In case the user has permissions to see all the orgz then the top org has to be derived.
156: IF l_top_organization_id=0 THEN
157:
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