APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on HR_ORGANIZATION_UNITS

Line 630: from hr_organization_units

626: )is
627:
628: cursor csr_org_name(p_id in number) is
629: select name
630: from hr_organization_units
631: where organization_id = p_id;
632:
633: cursor csr_job_name(p_id in number) is
634: select name

Line 2387: from hr_organization_units

2383: and asf.effective_start_date = l_effective_date;
2384:
2385: cursor csr_org_name(p_id in number) is
2386: select name
2387: from hr_organization_units
2388: where organization_id = p_id;
2389:
2390: cursor csr_job_name(p_id in number) is
2391: select name