APPS.HR_DE_ORG_INFO dependencies on HR_DE_ORGANIZATION_LINKS

Line 271: The table HR_DE_ORGANIZATION_LINKS holds relationships between an internal org and |

267: p_payroll_Betriebsnummer := l_pb_save;
268: END get_org_data_items;
269:
270: /*---------------------------------------------------------------------------------------------
271: The table HR_DE_ORGANIZATION_LINKS holds relationships between an internal org and |
272: external orgs (insurance providers in this case). One or more insurance companies may provide |
273: insurance for the orgainization. Get the details and put them in a table that can be returned |
274: to the caller |
275: ---------------------------------------------------------------------------------------------*/

Line 296: HR_DE_ORGANIZATION_LINKS HL,

292: HL.ORG_LINK_INFORMATION2 Class_Of_Risk,
293: HL.ORG_LINK_INFORMATION3 Membership_Number,
294: HU.NAME Name
295: from
296: HR_DE_ORGANIZATION_LINKS HL,
297: HR_ORGANIZATION_UNITS HU
298: where
299: Parent_Organization_id = c_org_id -- the internal org id
300: and Org_link_information_category = 'DE_LIABILITY_INSURANCE'

Line 386: HR_DE_ORGANIZATION_LINKS HL,

382: HL.ORG_LINK_INFORMATION2 Class_Of_Risk,
383: HL.ORG_LINK_INFORMATION3 Membership_Number,
384: rpad(HU.NAME, 240, ' ') Name
385: from
386: HR_DE_ORGANIZATION_LINKS HL,
387: HR_ORGANIZATION_UNITS HU
388: where
389: Parent_Organization_id = c_org_id -- the internal org id
390: and Org_link_information_category = 'DE_LIABILITY_INSURANCE'

Line 410: FROM hr_de_organization_links orl, hr_organization_units org

406: (SELECT unique(soft_coding_keyflex_id) FROM per_assignments_f WHERE assignment_id = p_assignment_id and p_incident_date BETWEEN effective_start_date AND effective_end_date);
407: IF SQL%FOUND THEN
408: IF l_exempt = 'N' THEN
409: SELECT org.name, NVL(orl.org_link_information3, 'NULL') INTO l_name, l_membership_no
410: FROM hr_de_organization_links orl, hr_organization_units org
411: WHERE orl.parent_organization_id = l_org_id
412: AND orl.child_organization_id = l_liab_prov
413: AND org.organization_id = l_liab_prov;
414: -- Copy to Global package variables

Line 750: HR_DE_ORGANIZATION_LINKS HL,

746: cursor c_sup_off (c_org_id hr_organization_units.organization_id%type) IS
747: SELECT Rpad(HL.CHILD_ORGANIZATION_ID, 15, ' ') child_org_id,
748: Rpad(HU.NAME, 240, ' ') Name
749: FROM
750: HR_DE_ORGANIZATION_LINKS HL,
751: HR_ORGANIZATION_UNITS HU
752: WHERE
753: Parent_Organization_id = c_org_id -- the internal org id
754: AND Org_link_type = 'DE_WRK_INC_SUP_OFF'