APPS.PA_TRX_IMPORT dependencies on PA_TASKS

Line 1310: pa_tasks t,

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
1314: and t.project_id = p_project_id

Line 2773: task_number = ( select task_number from pa_tasks

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 ;
2776:
2777: return ;