DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on PA_PROJECTS_EXPEND_V

Line 14608: FROM PA_PROJECTS_EXPEND_V

14604: IF x_charges_detail_rec.project_id is not null then
14605: BEGIN
14606: SELECT project_id
14607: INTO x_charges_detail_rec.project_id
14608: FROM PA_PROJECTS_EXPEND_V
14609: WHERE project_id = x_charges_detail_rec.project_id;
14610:
14611: If sql%rowcount=0 then
14612: x_charges_detail_rec.project_id := null;

Line 14774: FROM pa_projects_expend_v pp,

14770: SELECT pp.project_id,
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