eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_ABSENCE dependencies on HR_ORGANIZATION_INFORMATION

Line 575: ,HR_ORGANIZATION_INFORMATION hoi1

571: ,l_le_entitled_sc
572: ,l_le_exempt_empr
573: ,l_le_daily_rate
574: FROM HR_ORGANIZATION_UNITS o1
575: ,HR_ORGANIZATION_INFORMATION hoi1
576: ,HR_ORGANIZATION_INFORMATION hoi2
577: ,HR_ORGANIZATION_INFORMATION hoi3
578: ,HR_ORGANIZATION_INFORMATION hoi4
579: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 576: ,HR_ORGANIZATION_INFORMATION hoi2

572: ,l_le_exempt_empr
573: ,l_le_daily_rate
574: FROM HR_ORGANIZATION_UNITS o1
575: ,HR_ORGANIZATION_INFORMATION hoi1
576: ,HR_ORGANIZATION_INFORMATION hoi2
577: ,HR_ORGANIZATION_INFORMATION hoi3
578: ,HR_ORGANIZATION_INFORMATION hoi4
579: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
580: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 577: ,HR_ORGANIZATION_INFORMATION hoi3

573: ,l_le_daily_rate
574: FROM HR_ORGANIZATION_UNITS o1
575: ,HR_ORGANIZATION_INFORMATION hoi1
576: ,HR_ORGANIZATION_INFORMATION hoi2
577: ,HR_ORGANIZATION_INFORMATION hoi3
578: ,HR_ORGANIZATION_INFORMATION hoi4
579: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
580: FROM PER_ALL_ASSIGNMENTS_F ASG
581: ,HR_SOFT_CODING_KEYFLEX SCL

Line 578: ,HR_ORGANIZATION_INFORMATION hoi4

574: FROM HR_ORGANIZATION_UNITS o1
575: ,HR_ORGANIZATION_INFORMATION hoi1
576: ,HR_ORGANIZATION_INFORMATION hoi2
577: ,HR_ORGANIZATION_INFORMATION hoi3
578: ,HR_ORGANIZATION_INFORMATION hoi4
579: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
580: FROM PER_ALL_ASSIGNMENTS_F ASG
581: ,HR_SOFT_CODING_KEYFLEX SCL
582: WHERE ASG.ASSIGNMENT_ID = p_assignment_id

Line 7787: ,HR_ORGANIZATION_INFORMATION hoi1

7783:
7784: CURSOR csr_le_details is
7785: SELECT hoi4.ORG_INFORMATION10 AS restrict_hol_to_6G
7786: FROM HR_ORGANIZATION_UNITS o1
7787: ,HR_ORGANIZATION_INFORMATION hoi1
7788: ,HR_ORGANIZATION_INFORMATION hoi2
7789: ,HR_ORGANIZATION_INFORMATION hoi3
7790: ,HR_ORGANIZATION_INFORMATION hoi4
7791: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 7788: ,HR_ORGANIZATION_INFORMATION hoi2

7784: CURSOR csr_le_details is
7785: SELECT hoi4.ORG_INFORMATION10 AS restrict_hol_to_6G
7786: FROM HR_ORGANIZATION_UNITS o1
7787: ,HR_ORGANIZATION_INFORMATION hoi1
7788: ,HR_ORGANIZATION_INFORMATION hoi2
7789: ,HR_ORGANIZATION_INFORMATION hoi3
7790: ,HR_ORGANIZATION_INFORMATION hoi4
7791: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7792: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 7789: ,HR_ORGANIZATION_INFORMATION hoi3

7785: SELECT hoi4.ORG_INFORMATION10 AS restrict_hol_to_6G
7786: FROM HR_ORGANIZATION_UNITS o1
7787: ,HR_ORGANIZATION_INFORMATION hoi1
7788: ,HR_ORGANIZATION_INFORMATION hoi2
7789: ,HR_ORGANIZATION_INFORMATION hoi3
7790: ,HR_ORGANIZATION_INFORMATION hoi4
7791: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7792: FROM PER_ALL_ASSIGNMENTS_F ASG
7793: ,HR_SOFT_CODING_KEYFLEX SCL

Line 7790: ,HR_ORGANIZATION_INFORMATION hoi4

7786: FROM HR_ORGANIZATION_UNITS o1
7787: ,HR_ORGANIZATION_INFORMATION hoi1
7788: ,HR_ORGANIZATION_INFORMATION hoi2
7789: ,HR_ORGANIZATION_INFORMATION hoi3
7790: ,HR_ORGANIZATION_INFORMATION hoi4
7791: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7792: FROM PER_ALL_ASSIGNMENTS_F ASG
7793: ,HR_SOFT_CODING_KEYFLEX SCL
7794: WHERE ASG.ASSIGNMENT_ID = p_assignment_id