APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on PJM_ORG_PARAMETERS

Line 613: FROM pjm_org_parameters

609: BEGIN
610: BEGIN
611: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
612: INTO l_ispjm_org
613: FROM pjm_org_parameters
614: WHERE organization_id=p_organization_id;
615: EXCEPTION
616: WHEN NO_DATA_FOUND THEN
617: l_ispjm_org:='N';

Line 745: FROM pjm_org_parameters

741:
742: BEGIN
743: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
744: INTO l_ispjm_org
745: FROM pjm_org_parameters
746: WHERE organization_id=p_organization_id;
747: EXCEPTION
748: WHEN NO_DATA_FOUND THEN
749: l_ispjm_org:='N';

Line 2175: FROM pjm_org_parameters

2171: END IF;
2172: BEGIN
2173: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
2174: INTO l_ispjm_org
2175: FROM pjm_org_parameters
2176: WHERE organization_id=p_organization_id;
2177: EXCEPTION
2178: WHEN NO_DATA_FOUND THEN
2179: l_ispjm_org:='N';

Line 2363: FROM pjm_org_parameters

2359: END IF;
2360: BEGIN
2361: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
2362: INTO l_ispjm_org
2363: FROM pjm_org_parameters
2364: WHERE organization_id=p_organization_id;
2365: EXCEPTION
2366: WHEN NO_DATA_FOUND THEN
2367: l_ispjm_org:='N';

Line 3650: FROM pjm_org_parameters

3646:
3647: BEGIN
3648: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
3649: INTO l_ispjm_org
3650: FROM pjm_org_parameters
3651: WHERE organization_id=p_organization_id;
3652: EXCEPTION
3653: WHEN NO_DATA_FOUND THEN
3654: l_ispjm_org:='N';

Line 3833: FROM pjm_org_parameters

3829:
3830: BEGIN
3831: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
3832: INTO l_ispjm_org
3833: FROM pjm_org_parameters
3834: WHERE organization_id=p_organization_id;
3835: EXCEPTION
3836: WHEN NO_DATA_FOUND THEN
3837: l_ispjm_org:='N';

Line 4733: FROM pjm_org_parameters

4729: END IF;
4730: BEGIN
4731: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
4732: INTO l_ispjm_org
4733: FROM pjm_org_parameters
4734: WHERE organization_id=p_organization_id;
4735: EXCEPTION
4736: WHEN NO_DATA_FOUND THEN
4737: l_ispjm_org:='N';

Line 4863: FROM pjm_org_parameters

4859: BEGIN
4860: BEGIN
4861: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
4862: INTO l_ispjm_org
4863: FROM pjm_org_parameters
4864: WHERE organization_id=p_organization_id;
4865: EXCEPTION
4866: WHEN NO_DATA_FOUND THEN
4867: l_ispjm_org:='N';

Line 4995: FROM pjm_org_parameters

4991: BEGIN
4992: BEGIN
4993: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
4994: INTO l_ispjm_org
4995: FROM pjm_org_parameters
4996: WHERE organization_id=p_organization_id;
4997: EXCEPTION
4998: WHEN NO_DATA_FOUND THEN
4999: l_ispjm_org:='N';

Line 5137: FROM pjm_org_parameters

5133: BEGIN
5134: BEGIN
5135: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5136: INTO l_ispjm_org
5137: FROM pjm_org_parameters
5138: WHERE organization_id=p_organization_id;
5139: EXCEPTION
5140: WHEN NO_DATA_FOUND THEN
5141: l_ispjm_org:='N';

Line 5288: FROM pjm_org_parameters

5284: BEGIN
5285: BEGIN
5286: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5287: INTO l_ispjm_org
5288: FROM pjm_org_parameters
5289: WHERE organization_id=p_organization_id;
5290: EXCEPTION
5291: WHEN NO_DATA_FOUND THEN
5292: l_ispjm_org:='N';

Line 5477: FROM pjm_org_parameters

5473: BEGIN
5474: BEGIN
5475: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5476: INTO l_ispjm_org
5477: FROM pjm_org_parameters
5478: WHERE organization_id=p_organization_id;
5479: EXCEPTION
5480: WHEN NO_DATA_FOUND THEN
5481: l_ispjm_org:='N';

Line 5668: FROM pjm_org_parameters

5664: END IF;
5665: BEGIN
5666: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5667: INTO l_ispjm_org
5668: FROM pjm_org_parameters
5669: WHERE organization_id=p_organization_id;
5670: EXCEPTION
5671: WHEN NO_DATA_FOUND THEN
5672: l_ispjm_org:='N';

Line 5847: FROM pjm_org_parameters

5843: BEGIN
5844: BEGIN
5845: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
5846: INTO l_ispjm_org
5847: FROM pjm_org_parameters
5848: WHERE organization_id=p_organization_id;
5849: EXCEPTION
5850: WHEN NO_DATA_FOUND THEN
5851: l_ispjm_org:='N';

Line 6027: FROM pjm_org_parameters

6023: END IF;
6024: BEGIN
6025: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6026: INTO l_ispjm_org
6027: FROM pjm_org_parameters
6028: WHERE organization_id=p_organization_id;
6029: EXCEPTION
6030: WHEN NO_DATA_FOUND THEN
6031: l_ispjm_org:='N';

Line 6256: FROM pjm_org_parameters

6252: BEGIN
6253: BEGIN
6254: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6255: INTO l_ispjm_org
6256: FROM pjm_org_parameters
6257: WHERE organization_id=p_organization_id;
6258: EXCEPTION
6259: WHEN NO_DATA_FOUND THEN
6260: l_ispjm_org:='N';

Line 6316: FROM pjm_org_parameters

6312: END IF;
6313: BEGIN
6314: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
6315: INTO l_ispjm_org
6316: FROM pjm_org_parameters
6317: WHERE organization_id=p_organization_id;
6318: EXCEPTION
6319: WHEN NO_DATA_FOUND THEN
6320: l_ispjm_org:='N';