DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_POSTING dependencies on HR_ORGANIZATION_UNITS

Line 4867: From hr_organization_units

4863:
4864:
4865: Cursor csr_hr_org_name(p_organization_id NUMBER) is
4866: Select name
4867: From hr_organization_units
4868: Where organization_id = p_organization_id
4869: AND business_group_id = l_bg_id;
4870:
4871: Cursor csr_pa_project_num (p_project_id NUMBER) IS

Line 4929: l_table := 'HR_ORGANIZATION_UNITS';

4925: FETCH csr_hr_org_name INTO l_org_name;
4926: IF (csr_hr_org_name%NOTFOUND) THEN
4927: CLOSE csr_hr_org_name;
4928: l_value := 'Org id ='||to_char(C1.organization_id);
4929: l_table := 'HR_ORGANIZATION_UNITS';
4930: RAISE tran_setup_exception;
4931: else
4932: CLOSE csr_hr_org_name;
4933: hr_utility.set_location('org name : '||l_org_name, 22);