APPS.PQH_GL_POSTING dependencies on HR_ORGANIZATION_UNITS

Line 2589: l_organization_name hr_organization_units.name%TYPE;

2585: l_proc varchar2(72) := g_package||'set_bdt_log_context';
2586: l_budget_details_rec pqh_budget_details%ROWTYPE;
2587: l_position_name hr_positions.name%TYPE;
2588: l_job_name per_jobs.name%TYPE;
2589: l_organization_name hr_organization_units.name%TYPE;
2590: l_grade_name per_grades.name%TYPE;
2591:
2592: CURSOR csr_bdt_detail_rec IS
2593: SELECT *

Line 3924: from hr_organization_units table and assign to g_seg_val_tab table

3920: ) IS
3921: /*
3922: For the about budget_detail_id ,it will check if the Organization ID is not null.
3923: If the Organization is not null, we would get the defaults for this Organization ID
3924: from hr_organization_units table and assign to g_seg_val_tab table
3925: We would only assign those segments which are not null. That way we would only override the segments
3926: which were set by payroll if the segment value at this level is not null.
3927:
3928: */

Line 5834: From hr_organization_units

5830:
5831:
5832: Cursor csr_hr_org_name(p_organization_id NUMBER) is
5833: Select name
5834: From hr_organization_units
5835: Where organization_id = p_organization_id
5836: AND business_group_id = l_bg_id;
5837:
5838: Cursor csr_pa_project_num (p_project_id NUMBER) IS

Line 5896: l_table := 'HR_ORGANIZATION_UNITS';

5892: FETCH csr_hr_org_name INTO l_org_name;
5893: IF (csr_hr_org_name%NOTFOUND) THEN
5894: CLOSE csr_hr_org_name;
5895: l_value := 'Org id ='||to_char(C1.organization_id);
5896: l_table := 'HR_ORGANIZATION_UNITS';
5897: RAISE tran_setup_exception;
5898: else
5899: CLOSE csr_hr_org_name;
5900: hr_utility.set_location('org name : '||l_org_name, 22);