APPS.PA_BILLING dependencies on PA_TASKS

Line 252: FROM pa_tasks t

248: decode(fund_level,
249: 'PROJECT', decode(X2_task_id, NULL, NULL, X2_task_id),
250: 'TASK', t.top_task_id,
251: t.top_task_id) tpid
252: FROM pa_tasks t
253: WHERE t.project_id = X_project_id
254: AND t.task_id = nvl(X2_task_id, t.task_id)
255: AND t.ready_to_distribute_flag =
256: decode(x_calling_process, 'Revenue', 'Y', 'Both', 'Y',

Line 1807: from pa_tasks t, pa_expenditure_items_all e

1803: /* Indicator variables Bug# 634414 */
1804: NC := 1206;
1805: select t.labor_sch_type
1806: into labor_sch_type
1807: from pa_tasks t, pa_expenditure_items_all e
1808: where t.task_id = e.task_id
1809: and e.expenditure_item_id = ei_id( j );
1810: /* Indicator variables Bug# 634414 */
1811: NC := 1207;

Line 2164: from pa_tasks

2160: Select 'Y'
2161: Into l_exist_flag
2162: From dual
2163: Where exists ( select null
2164: from pa_tasks
2165: where project_id = p_project_id
2166: and customer_id = p_customer_id
2167: and task_id = top_task_id
2168: and decode(p_task_id