DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on PA_TASKS_EXPEND_V

Line 14643: FROM PA_TASKS_EXPEND_V

14639: IF x_charges_detail_rec.project_task_id is not null then
14640: BEGIN
14641: SELECT task_id
14642: INTO x_charges_detail_rec.project_task_id
14643: FROM PA_TASKS_EXPEND_V
14644: WHERE task_id = x_charges_detail_rec.project_task_id;
14645:
14646: If sql%rowcount=0 then
14647: x_charges_detail_rec.project_task_id := null;

Line 14775: pa_tasks_expend_v pt,

14771: pt.task_id ,
14772: HOU.organization_id
14773: INTO x_charges_detail_rec.project_id ,x_charges_detail_rec.project_task_id ,x_charges_detail_rec.expenditure_org_id
14774: FROM pa_projects_expend_v pp,
14775: pa_tasks_expend_v pt,
14776: pa_organizations_expend_v hou
14777: WHERE pp.project_id = pt.project_id
14778: AND pp.project_id = x_charges_detail_rec.project_id
14779: AND pt.task_id = x_charges_detail_rec.project_task_id