APPS.PER_PL_ORG_INFO dependencies on HR_ORGANIZATION_UNITS

Line 149: hr_organization_units where organization_id = ORG_ID;

145: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));
146:
147: cursor csr_org_dates is
148: select date_from, nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) from
149: hr_organization_units where organization_id = ORG_ID;
150:
151: overlap_found number;
152: org_start_date date;
153: org_end_date date;

Line 221: hr_organization_units where organization_id = p_org_id;

217: and org_information_id <> P_ORG_INFORMATION_ID;
218:
219: cursor csr_org_dates is
220: select date_from, nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) from
221: hr_organization_units where organization_id = p_org_id;
222:
223: overlap_upd_found number;
224: org_start_date date;
225: org_end_date date;

Line 404: p_org_id hr_organization_units.organization_id%TYPE;

400: cursor csr_org_id is
401: select organization_id from hr_organization_information where
402: org_information_id = P_ORG_INFORMATION_ID;
403:
404: p_org_id hr_organization_units.organization_id%TYPE;
405:
406: BEGIN
407:
408: /* Added for GSI Bug 5472781 */