DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on PJM_ORG_PARAMETERS

Line 946: FROM pjm_org_parameters

942: BEGIN
943: BEGIN
944: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
945: INTO l_ispjm_org
946: FROM pjm_org_parameters
947: WHERE organization_id=p_organization_id;
948: EXCEPTION
949: WHEN NO_DATA_FOUND THEN
950: l_ispjm_org:='N';

Line 1080: FROM pjm_org_parameters

1076:
1077: BEGIN
1078: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
1079: INTO l_ispjm_org
1080: FROM pjm_org_parameters
1081: WHERE organization_id=p_organization_id;
1082: EXCEPTION
1083: WHEN NO_DATA_FOUND THEN
1084: l_ispjm_org:='N';

Line 2552: FROM pjm_org_parameters

2548: END IF;
2549: BEGIN
2550: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
2551: INTO l_ispjm_org
2552: FROM pjm_org_parameters
2553: WHERE organization_id=p_organization_id;
2554: EXCEPTION
2555: WHEN NO_DATA_FOUND THEN
2556: l_ispjm_org:='N';

Line 2740: FROM pjm_org_parameters

2736: END IF;
2737: BEGIN
2738: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
2739: INTO l_ispjm_org
2740: FROM pjm_org_parameters
2741: WHERE organization_id=p_organization_id;
2742: EXCEPTION
2743: WHEN NO_DATA_FOUND THEN
2744: l_ispjm_org:='N';

Line 4069: FROM pjm_org_parameters

4065:
4066: BEGIN
4067: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
4068: INTO l_ispjm_org
4069: FROM pjm_org_parameters
4070: WHERE organization_id=p_organization_id;
4071: EXCEPTION
4072: WHEN NO_DATA_FOUND THEN
4073: l_ispjm_org:='N';

Line 4254: FROM pjm_org_parameters

4250:
4251: BEGIN
4252: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
4253: INTO l_ispjm_org
4254: FROM pjm_org_parameters
4255: WHERE organization_id=p_organization_id;
4256: EXCEPTION
4257: WHEN NO_DATA_FOUND THEN
4258: l_ispjm_org:='N';

Line 5190: FROM pjm_org_parameters

5186: END IF;
5187: BEGIN
5188: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5189: INTO l_ispjm_org
5190: FROM pjm_org_parameters
5191: WHERE organization_id=p_organization_id;
5192: EXCEPTION
5193: WHEN NO_DATA_FOUND THEN
5194: l_ispjm_org:='N';

Line 5323: FROM pjm_org_parameters

5319: BEGIN
5320: BEGIN
5321: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5322: INTO l_ispjm_org
5323: FROM pjm_org_parameters
5324: WHERE organization_id=p_organization_id;
5325: EXCEPTION
5326: WHEN NO_DATA_FOUND THEN
5327: l_ispjm_org:='N';

Line 5458: FROM pjm_org_parameters

5454: BEGIN
5455: BEGIN
5456: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5457: INTO l_ispjm_org
5458: FROM pjm_org_parameters
5459: WHERE organization_id=p_organization_id;
5460: EXCEPTION
5461: WHEN NO_DATA_FOUND THEN
5462: l_ispjm_org:='N';

Line 5603: FROM pjm_org_parameters

5599: BEGIN
5600: BEGIN
5601: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5602: INTO l_ispjm_org
5603: FROM pjm_org_parameters
5604: WHERE organization_id=p_organization_id;
5605: EXCEPTION
5606: WHEN NO_DATA_FOUND THEN
5607: l_ispjm_org:='N';

Line 5757: FROM pjm_org_parameters

5753: BEGIN
5754: BEGIN
5755: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5756: INTO l_ispjm_org
5757: FROM pjm_org_parameters
5758: WHERE organization_id=p_organization_id;
5759: EXCEPTION
5760: WHEN NO_DATA_FOUND THEN
5761: l_ispjm_org:='N';

Line 5949: FROM pjm_org_parameters

5945: BEGIN
5946: BEGIN
5947: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5948: INTO l_ispjm_org
5949: FROM pjm_org_parameters
5950: WHERE organization_id=p_organization_id;
5951: EXCEPTION
5952: WHEN NO_DATA_FOUND THEN
5953: l_ispjm_org:='N';

Line 6143: FROM pjm_org_parameters

6139: END IF;
6140: BEGIN
6141: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6142: INTO l_ispjm_org
6143: FROM pjm_org_parameters
6144: WHERE organization_id=p_organization_id;
6145: EXCEPTION
6146: WHEN NO_DATA_FOUND THEN
6147: l_ispjm_org:='N';

Line 6325: FROM pjm_org_parameters

6321: BEGIN
6322: BEGIN
6323: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6324: INTO l_ispjm_org
6325: FROM pjm_org_parameters
6326: WHERE organization_id=p_organization_id;
6327: EXCEPTION
6328: WHEN NO_DATA_FOUND THEN
6329: l_ispjm_org:='N';

Line 6508: FROM pjm_org_parameters

6504: END IF;
6505: BEGIN
6506: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6507: INTO l_ispjm_org
6508: FROM pjm_org_parameters
6509: WHERE organization_id=p_organization_id;
6510: EXCEPTION
6511: WHEN NO_DATA_FOUND THEN
6512: l_ispjm_org:='N';

Line 6741: FROM pjm_org_parameters

6737: BEGIN
6738: BEGIN
6739: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6740: INTO l_ispjm_org
6741: FROM pjm_org_parameters
6742: WHERE organization_id=p_organization_id;
6743: EXCEPTION
6744: WHEN NO_DATA_FOUND THEN
6745: l_ispjm_org:='N';

Line 6801: FROM pjm_org_parameters

6797: END IF;
6798: BEGIN
6799: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6800: INTO l_ispjm_org
6801: FROM pjm_org_parameters
6802: WHERE organization_id=p_organization_id;
6803: EXCEPTION
6804: WHEN NO_DATA_FOUND THEN
6805: l_ispjm_org:='N';

Line 6935: FROM pjm_org_parameters

6931:
6932: BEGIN
6933: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6934: INTO l_ispjm_org
6935: FROM pjm_org_parameters
6936: WHERE organization_id=p_organization_id;
6937: EXCEPTION
6938: WHEN NO_DATA_FOUND THEN
6939: l_ispjm_org:='N';