DBA Data[Home] [Help]

APPS.PQH_GL_POSTING dependencies on PA_PROJECTS_ALL

Line 5840: From pa_projects_all

5836: AND business_group_id = l_bg_id;
5837:
5838: Cursor csr_pa_project_num (p_project_id NUMBER) IS
5839: Select segment1,org_id
5840: From pa_projects_all
5841: Where project_id = p_project_id;
5842:
5843:
5844: Cursor csr_pa_task_num(p_task_id NUMBER) IS

Line 5911: l_table := 'PA_PROJECTS_ALL';

5907: FETCH csr_pa_project_num INTO l_seg1,l_org_id;
5908: IF (csr_pa_project_num%NOTFOUND) THEN
5909: CLOSE csr_pa_project_num;
5910: l_value := 'Project id ='||to_char(C1.project_id);
5911: l_table := 'PA_PROJECTS_ALL';
5912: RAISE tran_setup_exception;
5913: else
5914: CLOSE csr_pa_project_num;
5915: hr_utility.set_location('project number : '||l_seg1, 22);