APPS.PA_BILLING_SCHEDULE_PUB dependencies on PA_PROJECTS_PRM_V

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

83: x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
84: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
85: ) IS
86:
87: --Derive bill_job_group_id from pa_projects_prm_v using project-task id.
88: CURSOR cur_job_group IS
89: SELECT bill_job_group_id
90: FROM pa_projects_prm_v
91: WHERE project_id = p_project_id;

Line 90: FROM pa_projects_prm_v

86:
87: --Derive bill_job_group_id from pa_projects_prm_v using project-task id.
88: CURSOR cur_job_group IS
89: SELECT bill_job_group_id
90: FROM pa_projects_prm_v
91: WHERE project_id = p_project_id;
92: --AND task_id = decode( p_task_id, FND_API.G_MISS_NUM, p_task_id );
93:
94: l_api_name CONSTANT VARCHAR(30) := 'Update_Project_Task_Bill_Info';

Line 230: /* --Derive bill_job_group_id from pa_projects_prm_v using project-task id.

226: if (p_debug_mode = 'Y') then
227: pa_debug.debug('Update Billing Info PUB : Checking Job bill rate schedule id');
228: end if;
229:
230: /* --Derive bill_job_group_id from pa_projects_prm_v using project-task id.
231: SELECT bill_job_group_id
232: INTO l_job_group_id
233: FROM pa_projects_prm_v
234: WHERE project_id = p_project_id;

Line 233: FROM pa_projects_prm_v

229:
230: /* --Derive bill_job_group_id from pa_projects_prm_v using project-task id.
231: SELECT bill_job_group_id
232: INTO l_job_group_id
233: FROM pa_projects_prm_v
234: WHERE project_id = p_project_id;
235: --AND task_id = decode( p_task_id, FND_API.G_MISS_NUM, p_task_id );*/
236:
237: l_job_group_id := PA_BILLING_SCHEDULE_UTILS.Get_Job_Group_Id(