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 2385: from hr_organization_units

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