DBA Data[Home] [Help]

APPS.PA_BILLING_SCHEDULE_UTILS dependencies on PA_PROJECTS_PRM_V

Line 783: --Derive bill_job_group_id from pa_projects_prm_v using project-task id.

779: p_project_id NUMBER ,
780: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
781: ) RETURN NUMBER AS
782:
783: --Derive bill_job_group_id from pa_projects_prm_v using project-task id.
784: CURSOR cur_job_group IS
785: SELECT bill_job_group_id
786: FROM pa_projects_prm_v
787: WHERE project_id = p_project_id;

Line 786: FROM pa_projects_prm_v

782:
783: --Derive bill_job_group_id from pa_projects_prm_v using project-task id.
784: CURSOR cur_job_group IS
785: SELECT bill_job_group_id
786: FROM pa_projects_prm_v
787: WHERE project_id = p_project_id;
788: l_job_group_id NUMBER;
789:
790: BEGIN