APPS.PA_PROJECT_ASSETS_PUB dependencies on PA_PROJECT_TYPES

Line 108: pa_project_types t

104: --Used to determine if the project is CAPITAL
105: CURSOR capital_project_cur(x_project_id NUMBER) IS
106: SELECT 'Project is CAPITAL'
107: FROM pa_projects p,
108: pa_project_types t
109: WHERE p.project_id = x_project_id
110: AND p.project_type = t.project_type
111: AND t.project_type_class_code = 'CAPITAL';
112:

Line 1352: FROM pa_project_types pt,

1348: --are NOT NULL if the Project Asset Type is AS-BUILT and Complete Asset Definition is required
1349:
1350: SELECT NVL(pt.interface_complete_asset_flag,'N')
1351: INTO v_intf_complete_asset_flag
1352: FROM pa_project_types pt,
1353: pa_projects p
1354: WHERE p.project_type = pt.project_type
1355: AND p.project_id = l_project_id;
1356:

Line 1908: pa_project_types t

1904: --Used to determine if the project is CAPITAL
1905: CURSOR capital_project_cur(x_project_id NUMBER) IS
1906: SELECT 'Project is CAPITAL'
1907: FROM pa_projects p,
1908: pa_project_types t
1909: WHERE p.project_id = x_project_id
1910: AND p.project_type = t.project_type
1911: AND t.project_type_class_code = 'CAPITAL';
1912:

Line 2874: pa_project_types t

2870: --Used to determine if the project is CAPITAL
2871: CURSOR capital_project_cur(x_project_id NUMBER) IS
2872: SELECT 'Project is CAPITAL'
2873: FROM pa_projects p,
2874: pa_project_types t
2875: WHERE p.project_id = x_project_id
2876: AND p.project_type = t.project_type
2877: AND t.project_type_class_code = 'CAPITAL';
2878:

Line 5117: FROM pa_project_types pt,

5113: --are NOT NULL if the Project Asset Type is AS-BUILT and Complete Asset Definition is required
5114:
5115: SELECT NVL(pt.interface_complete_asset_flag,'N')
5116: INTO v_intf_complete_asset_flag
5117: FROM pa_project_types pt,
5118: pa_projects p
5119: WHERE p.project_type = pt.project_type
5120: AND p.project_id = l_project_id;
5121:

Line 6714: pa_project_types t

6710: --Used to determine if the project is CAPITAL
6711: CURSOR capital_project_cur(x_project_id NUMBER) IS
6712: SELECT 'Project is CAPITAL'
6713: FROM pa_projects p,
6714: pa_project_types t
6715: WHERE p.project_id = x_project_id
6716: AND p.project_type = t.project_type
6717: AND t.project_type_class_code = 'CAPITAL';
6718:

Line 7117: pa_project_types t

7113: --Used to determine if the project is CAPITAL
7114: CURSOR capital_project_cur(x_project_id NUMBER) IS
7115: SELECT 'Project is CAPITAL'
7116: FROM pa_projects p,
7117: pa_project_types t
7118: WHERE p.project_id = x_project_id
7119: AND p.project_type = t.project_type
7120: AND t.project_type_class_code = 'CAPITAL';
7121: