APPS.PJI_PMV_UTIL dependencies on DUAL

Line 340: SELECT userenv('LANG') INTO l_User_Lang FROM dual;

336: l_User_Lang VARCHAR2(52);
337: BEGIN
338: --Bug 5598041: Invoke Init procedure if the labels are not populated in the correct language
339: BEGIN
340: SELECT userenv('LANG') INTO l_User_Lang FROM dual;
341: IF G_User_Lang <> l_User_Lang THEN
342: Init;
343: END IF;
344: EXCEPTION

Line 454: SELECT userenv('LANG') INTO l_User_Lang FROM dual;

450: l_User_Lang VARCHAR2(52);
451: BEGIN
452: --Bug 5598041: Invoke Init procedure if labels are not populated in the correct language
453: BEGIN
454: SELECT userenv('LANG') INTO l_User_Lang FROM dual;
455: IF G_User_Lang <> l_User_Lang THEN
456: Init;
457: END IF;
458: EXCEPTION

Line 1168: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS

1164: x_insert_top_org_flag => l_insert_top_org_flag);
1165:
1166: BEGIN
1167: IF l_top_organization_id = 0 THEN
1168: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
1169: (SELECT orgd.organization_id_child
1170: FROM
1171: per_org_structure_elements orgd
1172: , pji_system_settings pset

Line 1182: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS

1178:
1179: RETURN l_org_id;
1180: ELSIF l_user_assmt_flag = 'N' THEN
1181:
1182: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
1183: (SELECT orgd.organization_id_child
1184: FROM
1185: per_org_structure_elements orgd
1186: , pji_system_settings pset

Line 1199: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS

1195:
1196: RETURN l_org_id;
1197: ELSIF l_user_assmt_flag = 'Y' THEN
1198:
1199: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
1200: (SELECT orgd.organization_id_child
1201: FROM
1202: per_org_structure_elements orgd
1203: , pji_system_settings pset

Line 1226: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS

1222:
1223: --Bug 4599990.In case the user has permissions to see all the orgz then the top org has to be derived.
1224: IF l_top_organization_id=0 THEN
1225:
1226: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
1227: (SELECT orgd.organization_id_child
1228: FROM
1229: (select distinct organization_id_parent organization_id_child, NULL organization_id_parent from
1230: per_org_structure_elements p

Line 1328: FROM dual;

1324: --Bug 5598041: G_User_Lang will hold the language name in which the labels are being populated
1325: BEGIN
1326: SELECT userenv('LANG')
1327: INTO G_User_Lang
1328: FROM dual;
1329: EXCEPTION
1330: WHEN NO_DATA_FOUND THEN
1331: NULL;
1332: END;