APPS.PA_TRX_IMPORT dependencies on PA_TASKS

Line 1219: pa_tasks t,

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

Line 2510: task_number = ( select task_number from pa_tasks

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 ;
2513:
2514: return ;