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 548: ,HR_ORGANIZATION_INFORMATION hoi1

544: ,l_le_entitled_sc
545: ,l_le_exempt_empr
546: ,l_le_daily_rate
547: FROM HR_ORGANIZATION_UNITS o1
548: ,HR_ORGANIZATION_INFORMATION hoi1
549: ,HR_ORGANIZATION_INFORMATION hoi2
550: ,HR_ORGANIZATION_INFORMATION hoi3
551: ,HR_ORGANIZATION_INFORMATION hoi4
552: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 549: ,HR_ORGANIZATION_INFORMATION hoi2

545: ,l_le_exempt_empr
546: ,l_le_daily_rate
547: FROM HR_ORGANIZATION_UNITS o1
548: ,HR_ORGANIZATION_INFORMATION hoi1
549: ,HR_ORGANIZATION_INFORMATION hoi2
550: ,HR_ORGANIZATION_INFORMATION hoi3
551: ,HR_ORGANIZATION_INFORMATION hoi4
552: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
553: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 550: ,HR_ORGANIZATION_INFORMATION hoi3

546: ,l_le_daily_rate
547: FROM HR_ORGANIZATION_UNITS o1
548: ,HR_ORGANIZATION_INFORMATION hoi1
549: ,HR_ORGANIZATION_INFORMATION hoi2
550: ,HR_ORGANIZATION_INFORMATION hoi3
551: ,HR_ORGANIZATION_INFORMATION hoi4
552: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
553: FROM PER_ALL_ASSIGNMENTS_F ASG
554: ,HR_SOFT_CODING_KEYFLEX SCL

Line 551: ,HR_ORGANIZATION_INFORMATION hoi4

547: FROM HR_ORGANIZATION_UNITS o1
548: ,HR_ORGANIZATION_INFORMATION hoi1
549: ,HR_ORGANIZATION_INFORMATION hoi2
550: ,HR_ORGANIZATION_INFORMATION hoi3
551: ,HR_ORGANIZATION_INFORMATION hoi4
552: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
553: FROM PER_ALL_ASSIGNMENTS_F ASG
554: ,HR_SOFT_CODING_KEYFLEX SCL
555: WHERE ASG.ASSIGNMENT_ID = p_assignment_id

Line 7682: ,HR_ORGANIZATION_INFORMATION hoi1

7678:
7679: CURSOR csr_le_details is
7680: SELECT hoi4.ORG_INFORMATION10 AS restrict_hol_to_6G
7681: FROM HR_ORGANIZATION_UNITS o1
7682: ,HR_ORGANIZATION_INFORMATION hoi1
7683: ,HR_ORGANIZATION_INFORMATION hoi2
7684: ,HR_ORGANIZATION_INFORMATION hoi3
7685: ,HR_ORGANIZATION_INFORMATION hoi4
7686: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 7683: ,HR_ORGANIZATION_INFORMATION hoi2

7679: CURSOR csr_le_details is
7680: SELECT hoi4.ORG_INFORMATION10 AS restrict_hol_to_6G
7681: FROM HR_ORGANIZATION_UNITS o1
7682: ,HR_ORGANIZATION_INFORMATION hoi1
7683: ,HR_ORGANIZATION_INFORMATION hoi2
7684: ,HR_ORGANIZATION_INFORMATION hoi3
7685: ,HR_ORGANIZATION_INFORMATION hoi4
7686: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7687: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 7684: ,HR_ORGANIZATION_INFORMATION hoi3

7680: SELECT hoi4.ORG_INFORMATION10 AS restrict_hol_to_6G
7681: FROM HR_ORGANIZATION_UNITS o1
7682: ,HR_ORGANIZATION_INFORMATION hoi1
7683: ,HR_ORGANIZATION_INFORMATION hoi2
7684: ,HR_ORGANIZATION_INFORMATION hoi3
7685: ,HR_ORGANIZATION_INFORMATION hoi4
7686: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7687: FROM PER_ALL_ASSIGNMENTS_F ASG
7688: ,HR_SOFT_CODING_KEYFLEX SCL

Line 7685: ,HR_ORGANIZATION_INFORMATION hoi4

7681: FROM HR_ORGANIZATION_UNITS o1
7682: ,HR_ORGANIZATION_INFORMATION hoi1
7683: ,HR_ORGANIZATION_INFORMATION hoi2
7684: ,HR_ORGANIZATION_INFORMATION hoi3
7685: ,HR_ORGANIZATION_INFORMATION hoi4
7686: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7687: FROM PER_ALL_ASSIGNMENTS_F ASG
7688: ,HR_SOFT_CODING_KEYFLEX SCL
7689: WHERE ASG.ASSIGNMENT_ID = p_assignment_id