DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 14681: FROM PA_ORGANIZATIONS_EXPEND_V

14677: IF x_charges_detail_rec.expenditure_org_id is not null then
14678: BEGIN
14679: SELECT organization_id
14680: INTO x_charges_detail_rec.expenditure_org_id
14681: FROM PA_ORGANIZATIONS_EXPEND_V
14682: WHERE organization_id = x_charges_detail_rec.expenditure_org_id;
14683:
14684: If sql%rowcount=0 then
14685: x_charges_detail_rec.expenditure_org_id := null;

Line 14776: pa_organizations_expend_v hou

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
14780: AND hou.organization_id =x_charges_detail_rec.expenditure_org_id ;