DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_POSTING dependencies on PA_PROJECTS_ALL

Line 4873: From pa_projects_all

4869: AND business_group_id = l_bg_id;
4870:
4871: Cursor csr_pa_project_num (p_project_id NUMBER) IS
4872: Select segment1,org_id
4873: From pa_projects_all
4874: Where project_id = p_project_id;
4875:
4876:
4877: Cursor csr_pa_task_num(p_task_id NUMBER) IS

Line 4944: l_table := 'PA_PROJECTS_ALL';

4940: FETCH csr_pa_project_num INTO l_seg1,l_org_id;
4941: IF (csr_pa_project_num%NOTFOUND) THEN
4942: CLOSE csr_pa_project_num;
4943: l_value := 'Project id ='||to_char(C1.project_id);
4944: l_table := 'PA_PROJECTS_ALL';
4945: RAISE tran_setup_exception;
4946: else
4947: CLOSE csr_pa_project_num;
4948: hr_utility.set_location('project number : '||l_seg1, 22);