APPS.PAY_SE_ABSENCE_USER dependencies on HR_ORGANIZATION_INFORMATION

Line 456: ,HR_ORGANIZATION_INFORMATION hoi1

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
460: AND hoi1.org_information_context = 'CLASS'

Line 457: ,HR_ORGANIZATION_INFORMATION hoi2

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
460: AND hoi1.org_information_context = 'CLASS'
461: AND hoi1.ORG_INFORMATION1='HR_LEGAL_EMPLOYER'

Line 469: ,HR_ORGANIZATION_INFORMATION hoi1

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
473: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 470: ,HR_ORGANIZATION_INFORMATION hoi2

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
473: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
474: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 471: ,HR_ORGANIZATION_INFORMATION hoi3

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
473: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
474: FROM PER_ALL_ASSIGNMENTS_F ASG
475: ,HR_SOFT_CODING_KEYFLEX SCL

Line 472: ,HR_ORGANIZATION_INFORMATION hoi4

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
473: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
474: FROM PER_ALL_ASSIGNMENTS_F ASG
475: ,HR_SOFT_CODING_KEYFLEX SCL
476: WHERE ASG.ASSIGNMENT_ID = p_assignment_id

Line 497: ,HR_ORGANIZATION_INFORMATION hoi1

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
501: AND hoi1.organization_id = p_tax_unit_id

Line 498: ,HR_ORGANIZATION_INFORMATION hoi2

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
501: AND hoi1.organization_id = p_tax_unit_id
502: AND hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 660: ,HR_ORGANIZATION_INFORMATION hoi1

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
664: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 661: ,HR_ORGANIZATION_INFORMATION hoi2

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
664: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
665: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 662: ,HR_ORGANIZATION_INFORMATION hoi3

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
664: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
665: FROM PER_ALL_ASSIGNMENTS_F ASG
666: ,HR_SOFT_CODING_KEYFLEX SCL

Line 663: ,HR_ORGANIZATION_INFORMATION hoi4

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
664: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
665: FROM PER_ALL_ASSIGNMENTS_F ASG
666: ,HR_SOFT_CODING_KEYFLEX SCL
667: WHERE ASG.ASSIGNMENT_ID = csr_v_assignment_id