APPS.PAY_SE_ABSENCE_USER dependencies on HR_ORGANIZATION_UNITS

Line 455: FROM HR_ORGANIZATION_UNITS hou

451:
452:
453: Cursor csr_Generate_Max_Days IS
454: SELECT hoi2.org_information2,hoi2.org_information3
455: FROM HR_ORGANIZATION_UNITS hou
456: ,HR_ORGANIZATION_INFORMATION hoi1
457: ,HR_ORGANIZATION_INFORMATION hoi2
458: WHERE hou.organization_id =p_tax_unit_id
459: AND hoi1.organization_id = hou.organization_id

Line 468: FROM HR_ORGANIZATION_UNITS o1

464: AND hoi2.org_information1 IS NOT NULL
465: AND hoi2.org_information1=p_category_code;
466:
467: /* SELECT hoi4.ORG_INFORMATION2,hoi4.ORG_INFORMATION3
468: FROM HR_ORGANIZATION_UNITS o1
469: ,HR_ORGANIZATION_INFORMATION hoi1
470: ,HR_ORGANIZATION_INFORMATION hoi2
471: ,HR_ORGANIZATION_INFORMATION hoi3
472: ,HR_ORGANIZATION_INFORMATION hoi4

Line 496: FROM HR_ORGANIZATION_UNITS o1

492: AND hoi4.org_information1=p_category_code;
493: */
494: Cursor csr_Earning_Year is
495: SELECT substr(hoi2.ORG_INFORMATION2,4,2)
496: FROM HR_ORGANIZATION_UNITS o1
497: ,HR_ORGANIZATION_INFORMATION hoi1
498: ,HR_ORGANIZATION_INFORMATION hoi2
499: WHERE
500: hoi1.organization_id = o1.organization_id

Line 659: FROM HR_ORGANIZATION_UNITS o1

655: csr_v_effective_date DATE,
656: csr_v_business_group_id NUMBER)
657: IS
658: SELECT substr(hoi4.ORG_INFORMATION2,4,2)
659: FROM HR_ORGANIZATION_UNITS o1
660: ,HR_ORGANIZATION_INFORMATION hoi1
661: ,HR_ORGANIZATION_INFORMATION hoi2
662: ,HR_ORGANIZATION_INFORMATION hoi3
663: ,HR_ORGANIZATION_INFORMATION hoi4