APPS.PA_TRX_IMPORT dependencies on PA_PROJECTS_ALL

Line 1098: FROM pa_projects_all proj,

1094: SELECT burden_cost_flag, project_type_class_code, burden_amt_display_method,
1095: total_burden_flag
1096: INTO X_proj_bcost_flag, X_proj_type_class, X_burden_amt_display_method,
1097: X_Total_Burden_Flag
1098: FROM pa_projects_all proj,
1099: pa_project_types_all ptype
1100: WHERE proj.project_type = ptype.project_type
1101: -- MOAC Changes
1102: AND proj.org_id = ptype.org_id

Line 1218: from pa_projects_all p,

1214: nvl(et.start_date_active, p_exp_item_date) et_start_date,
1215: nvl(et.end_date_active, p_exp_item_date) et_end_date,
1216: nvl(sl.start_date_active, p_exp_item_date) sl_start_date,
1217: nvl(sl.end_date_active, p_exp_item_date) sl_end_date
1218: from pa_projects_all p,
1219: pa_tasks t,
1220: pa_expenditure_types et,
1221: pa_expend_typ_sys_links sl
1222: where p.project_id = p_project_id

Line 2508: from pa_projects_all

2504: -- Following is done to support Query by project number or task number in the transaction review form.
2505: --
2506: update pa_transaction_interface_all
2507: Set project_number = ( select segment1
2508: from pa_projects_all
2509: where project_id = P_project_id ),
2510: task_number = ( select task_number from pa_tasks
2511: where task_id = P_task_id)
2512: where txn_interface_id = X_txn_interface_id ;