APPS.PA_LIFECYCLES_PUB dependencies on PA_LIFECYCLE_USAGES

Line 633: where exists( select 'XYZ' from pa_lifecycle_usages

629: begin
630: select 'Y'
631: into l_project_usage_exists
632: from SYS.DUAL
633: where exists( select 'XYZ' from pa_lifecycle_usages
634: where lifecycle_id=P_lifecycle_id AND
635: usage_type=c_project_type);
636: exception
637: when NO_DATA_FOUND then

Line 646: where exists( select 'XYZ' from pa_lifecycle_usages

642: begin
643: select 'Y'
644: into l_product_usage_exists
645: from SYS.DUAL
646: where exists( select 'XYZ' from pa_lifecycle_usages
647: where lifecycle_id=P_lifecycle_id AND
648: usage_type=c_product_type);
649: exception
650: when NO_DATA_FOUND then

Line 1008: where exists( select 'XYZ' from pa_lifecycle_usages

1004: begin
1005: select 'Y'
1006: into l_project_usage_exists
1007: from SYS.DUAL
1008: where exists( select 'XYZ' from pa_lifecycle_usages
1009: where lifecycle_id=P_lifecycle_id AND
1010: usage_type=c_project_type);
1011: exception
1012: when NO_DATA_FOUND then

Line 1021: where exists(select 'XYZ' from pa_lifecycle_usages

1017: begin
1018: select 'Y'
1019: into l_product_usage_exists
1020: from SYS.DUAL
1021: where exists(select 'XYZ' from pa_lifecycle_usages
1022: where lifecycle_id=P_lifecycle_id AND
1023: usage_type=c_product_type);
1024: exception
1025: when NO_DATA_FOUND then

Line 1411: where exists ( select '1' from pa_lifecycle_usages

1407: BEGIN
1408: select 'Y'
1409: into l_lifecycle_project_usage_type
1410: from SYS.DUAL
1411: where exists ( select '1' from pa_lifecycle_usages
1412: where lifecycle_id=l_lifecycle_id
1413: AND usage_type='PROJECTS');
1414: EXCEPTION
1415: when NO_DATA_FOUND then

Line 1430: where exists ( select '1' from pa_lifecycle_usages

1426: BEGIN
1427: select 'Y'
1428: into l_lifecycle_product_usage_type
1429: from SYS.DUAL
1430: where exists ( select '1' from pa_lifecycle_usages
1431: where lifecycle_id=l_lifecycle_id
1432: AND usage_type='PRODUCTS');
1433: EXCEPTION
1434: when NO_DATA_FOUND then