APPS.PA_TRX_IMPORT dependencies on PA_PROJECTS_ALL

Line 1180: FROM pa_projects_all proj,

1176: SELECT burden_cost_flag, project_type_class_code, burden_amt_display_method,
1177: total_burden_flag
1178: INTO X_proj_bcost_flag, X_proj_type_class, X_burden_amt_display_method,
1179: X_Total_Burden_Flag
1180: FROM pa_projects_all proj,
1181: pa_project_types_all ptype
1182: WHERE proj.project_type = ptype.project_type
1183: -- MOAC Changes
1184: AND proj.org_id = ptype.org_id

Line 1309: from pa_projects_all p,

1305: nvl(et.start_date_active, p_exp_item_date) et_start_date,
1306: nvl(et.end_date_active, p_exp_item_date) et_end_date,
1307: nvl(sl.start_date_active, p_exp_item_date) sl_start_date,
1308: nvl(sl.end_date_active, p_exp_item_date) sl_end_date
1309: from pa_projects_all p,
1310: pa_tasks t,
1311: pa_expenditure_types et,
1312: pa_expend_typ_sys_links sl
1313: where p.project_id = p_project_id

Line 2771: from pa_projects_all

2767: -- Following is done to support Query by project number or task number in the transaction review form.
2768: --
2769: update pa_transaction_interface_all
2770: Set project_number = ( select segment1
2771: from pa_projects_all
2772: where project_id = P_project_id ),
2773: task_number = ( select task_number from pa_tasks
2774: where task_id = P_task_id)
2775: where txn_interface_id = X_txn_interface_id ;

Line 3085: FROM PA_PROJECTS_ALL PAP, PA_RBS_ELEMENTS PRE

3081:
3082: BEGIN
3083: SELECT RBS_ELEMENT_ID
3084: INTO G_cbs_element_id
3085: FROM PA_PROJECTS_ALL PAP, PA_RBS_ELEMENTS PRE
3086: WHERE PAP.PROJECT_ID = G_project_id
3087: AND PRE.RBS_VERSION_ID = PAP.CBS_VERSION_ID
3088: AND PRE.COST_CODE = P_cbs_element_name;
3089: