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 2367: ,pa_project_types_all pt /** Bug fix 2262118 **/

2363: ,l_proj_type_class_code
2364: ,l_old_billability
2365: FROM pa_expenditure_items_all EI
2366: ,pa_transaction_sources tr
2367: ,pa_project_types_all pt /** Bug fix 2262118 **/
2368: ,pa_projects_all pp
2369: -- ,pa_tasks t /* Bug 3457922 */
2370: WHERE tr.transaction_source(+) = ei.transaction_source
2371: AND ei.expenditure_item_id = ItemsIdTab(i)

Line 5734: || ' FROM pa_project_types_all pt'

5730: end if;
5731:
5732: if x_billable_flag is not null then
5733: where_clause := where_clause || ' AND 1 = (SELECT 1'
5734: || ' FROM pa_project_types_all pt'
5735: || ' , pa_projects_all p'
5736: || ' WHERE p.project_type = pt.project_type'
5737: || ' AND p.org_id = pt.org_id'
5738: || ' AND p.project_id = ei.project_id'

Line 5773: || ' FROM pa_project_types_all pt'

5769: end if;
5770:
5771: if x_revenue_distributed_flag is not null then
5772: where_clause := where_clause || ' AND 1 = (SELECT 1'
5773: || ' FROM pa_project_types_all pt'
5774: || ' , pa_projects_all p'
5775: || ' WHERE p.project_type = pt.project_type'
5776: || ' AND p.org_id = pt.org_id'
5777: || ' AND p.project_id = ei.project_id'

Line 5995: || ' FROM pa_project_types_all pt'

5991: end if ;
5992:
5993: if x_capitalizable_flag is not null then
5994: where_clause := where_clause || ' AND 1 = (SELECT 1'
5995: || ' FROM pa_project_types_all pt'
5996: || ' , pa_projects_all p'
5997: || ' WHERE p.project_type = pt.project_type'
5998: || ' AND p.org_id = pt.org_id'
5999: || ' AND p.project_id = ei.project_id'

Line 6006: || ' FROM pa_project_types_all pt'

6002: end if;
6003:
6004: if x_grouped_cip_flag is not null then
6005: where_clause := where_clause || ' AND 1 = (SELECT 1'
6006: || ' FROM pa_project_types_all pt'
6007: || ' , pa_projects_all p'
6008: || ' WHERE p.project_type = pt.project_type'
6009: || ' AND p.org_id = pt.org_id'
6010: || ' AND p.project_id = ei.project_id'

Line 6021: || ' FROM pa_project_types_all pt'

6017: end if;
6018:
6019: if p_grouped_rwip_flag is not null then
6020: where_clause := where_clause || ' AND 1 = (SELECT 1'
6021: || ' FROM pa_project_types_all pt'
6022: || ' , pa_projects_all p'
6023: || ' WHERE p.project_type = pt.project_type'
6024: || ' AND p.org_id = pt.org_id'
6025: || ' AND p.project_id = ei.project_id'

Line 6036: || ' FROM pa_project_types_all pt'

6032: end if;
6033:
6034: if p_expensed_flag = 'Y' then /* Bug 5393328 */
6035: where_clause := where_clause || ' AND 1 = (SELECT 1'
6036: || ' FROM pa_project_types_all pt'
6037: || ' , pa_projects_all p'
6038: || ' WHERE p.project_type = pt.project_type'
6039: || ' AND p.org_id = pt.org_id'
6040: || ' AND p.project_id = ei.project_id'

Line 6403: FROM pa_project_types_all pt

6399: SELECT pt.project_type_class_code
6400: , p.project_status_code
6401: INTO v_project_type_class_code
6402: , l_project_status_code
6403: FROM pa_project_types_all pt
6404: , pa_projects_all p
6405: WHERE p.project_type = pt.project_type
6406: AND p.org_id = pt.org_id
6407: AND p.project_id = l_project_id;