APPS.PA_ADJUSTMENTS dependencies on PA_PROJECT_TYPES_ALL

Line 86: pa_project_types_all ptype

82: BEGIN
83: SELECT nvl(burden_cost_flag,'N')
84: INTO X_proj_bcost_flag
85: FROM pa_projects_all proj,
86: pa_project_types_all ptype
87: WHERE proj.project_type = ptype.project_type
88: AND nvl(proj.org_id, -99) = nvl(ptype.org_id,-99)
89: AND project_id = p_Project_id ;
90: return(X_proj_bcost_flag);

Line 145: pa_project_types_all pt /** Bug fix 2262118 **/

141: SELECT 'Y'
142: INTO l_billable
143: FROM pa_projects_all pp,
144: pa_tasks t,
145: pa_project_types_all pt /** Bug fix 2262118 **/
146: WHERE t.task_id = p_task_id
147: AND pp.project_id = t.project_id
148: AND pp.project_type = pt.project_type
149: AND pt.PROJECT_TYPE_CLASS_CODE in ('CAPITAL','CONTRACT')

Line 2311: ,pa_project_types_all pt /** Bug fix 2262118 **/

2307: ,l_proj_type_class_code
2308: ,l_old_billability
2309: FROM pa_expenditure_items_all EI
2310: ,pa_transaction_sources tr
2311: ,pa_project_types_all pt /** Bug fix 2262118 **/
2312: ,pa_projects_all pp
2313: -- ,pa_tasks t /* Bug 3457922 */
2314: WHERE tr.transaction_source(+) = ei.transaction_source
2315: AND ei.expenditure_item_id = ItemsIdTab(i)

Line 5604: || ' FROM pa_project_types_all pt'

5600: end if;
5601:
5602: if x_billable_flag is not null then
5603: where_clause := where_clause || ' AND 1 = (SELECT 1'
5604: || ' FROM pa_project_types_all pt'
5605: || ' , pa_projects_all p'
5606: || ' WHERE p.project_type = pt.project_type'
5607: || ' AND p.org_id = pt.org_id'
5608: || ' AND p.project_id = ei.project_id'

Line 5643: || ' FROM pa_project_types_all pt'

5639: end if;
5640:
5641: if x_revenue_distributed_flag is not null then
5642: where_clause := where_clause || ' AND 1 = (SELECT 1'
5643: || ' FROM pa_project_types_all pt'
5644: || ' , pa_projects_all p'
5645: || ' WHERE p.project_type = pt.project_type'
5646: || ' AND p.org_id = pt.org_id'
5647: || ' AND p.project_id = ei.project_id'

Line 5851: || ' FROM pa_project_types_all pt'

5847: end if ;
5848:
5849: if x_capitalizable_flag is not null then
5850: where_clause := where_clause || ' AND 1 = (SELECT 1'
5851: || ' FROM pa_project_types_all pt'
5852: || ' , pa_projects_all p'
5853: || ' WHERE p.project_type = pt.project_type'
5854: || ' AND p.org_id = pt.org_id'
5855: || ' AND p.project_id = ei.project_id'

Line 5862: || ' FROM pa_project_types_all pt'

5858: end if;
5859:
5860: if x_grouped_cip_flag is not null then
5861: where_clause := where_clause || ' AND 1 = (SELECT 1'
5862: || ' FROM pa_project_types_all pt'
5863: || ' , pa_projects_all p'
5864: || ' WHERE p.project_type = pt.project_type'
5865: || ' AND p.org_id = pt.org_id'
5866: || ' AND p.project_id = ei.project_id'

Line 5877: || ' FROM pa_project_types_all pt'

5873: end if;
5874:
5875: if p_grouped_rwip_flag is not null then
5876: where_clause := where_clause || ' AND 1 = (SELECT 1'
5877: || ' FROM pa_project_types_all pt'
5878: || ' , pa_projects_all p'
5879: || ' WHERE p.project_type = pt.project_type'
5880: || ' AND p.org_id = pt.org_id'
5881: || ' AND p.project_id = ei.project_id'

Line 5892: || ' FROM pa_project_types_all pt'

5888: end if;
5889:
5890: if p_expensed_flag = 'Y' then /* Bug 5393328 */
5891: where_clause := where_clause || ' AND 1 = (SELECT 1'
5892: || ' FROM pa_project_types_all pt'
5893: || ' , pa_projects_all p'
5894: || ' WHERE p.project_type = pt.project_type'
5895: || ' AND p.org_id = pt.org_id'
5896: || ' AND p.project_id = ei.project_id'

Line 6239: FROM pa_project_types_all pt

6235: SELECT pt.project_type_class_code
6236: , p.project_status_code
6237: INTO v_project_type_class_code
6238: , l_project_status_code
6239: FROM pa_project_types_all pt
6240: , pa_projects_all p
6241: WHERE p.project_type = pt.project_type
6242: AND p.org_id = pt.org_id
6243: AND p.project_id = l_project_id;