APPS.PAY_SE_ABSENCE dependencies on HR_ORGANIZATION_INFORMATION

Line 58: ,HR_ORGANIZATION_INFORMATION hoi1

54: CURSOR csr_Legal_Employer_Hourly_Rate IS
55: SELECT hoi4.ORG_INFORMATION1
56:
57: FROM HR_ORGANIZATION_UNITS o1
58: ,HR_ORGANIZATION_INFORMATION hoi1
59: ,HR_ORGANIZATION_INFORMATION hoi2
60: ,HR_ORGANIZATION_INFORMATION hoi3
61: ,HR_ORGANIZATION_INFORMATION hoi4
62: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 59: ,HR_ORGANIZATION_INFORMATION hoi2

55: SELECT hoi4.ORG_INFORMATION1
56:
57: FROM HR_ORGANIZATION_UNITS o1
58: ,HR_ORGANIZATION_INFORMATION hoi1
59: ,HR_ORGANIZATION_INFORMATION hoi2
60: ,HR_ORGANIZATION_INFORMATION hoi3
61: ,HR_ORGANIZATION_INFORMATION hoi4
62: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
63: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 60: ,HR_ORGANIZATION_INFORMATION hoi3

56:
57: FROM HR_ORGANIZATION_UNITS o1
58: ,HR_ORGANIZATION_INFORMATION hoi1
59: ,HR_ORGANIZATION_INFORMATION hoi2
60: ,HR_ORGANIZATION_INFORMATION hoi3
61: ,HR_ORGANIZATION_INFORMATION hoi4
62: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
63: FROM PER_ALL_ASSIGNMENTS_F ASG
64: ,HR_SOFT_CODING_KEYFLEX SCL

Line 61: ,HR_ORGANIZATION_INFORMATION hoi4

57: FROM HR_ORGANIZATION_UNITS o1
58: ,HR_ORGANIZATION_INFORMATION hoi1
59: ,HR_ORGANIZATION_INFORMATION hoi2
60: ,HR_ORGANIZATION_INFORMATION hoi3
61: ,HR_ORGANIZATION_INFORMATION hoi4
62: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
63: FROM PER_ALL_ASSIGNMENTS_F ASG
64: ,HR_SOFT_CODING_KEYFLEX SCL
65: WHERE ASG.ASSIGNMENT_ID = p_assignment_id

Line 86: ,HR_ORGANIZATION_INFORMATION hoi1

82: CURSOR csr_Legal_Employer_Salary_Rate IS
83: SELECT hoi4.ORG_INFORMATION1
84:
85: FROM HR_ORGANIZATION_UNITS o1
86: ,HR_ORGANIZATION_INFORMATION hoi1
87: ,HR_ORGANIZATION_INFORMATION hoi2
88: ,HR_ORGANIZATION_INFORMATION hoi3
89: ,HR_ORGANIZATION_INFORMATION hoi4
90: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 87: ,HR_ORGANIZATION_INFORMATION hoi2

83: SELECT hoi4.ORG_INFORMATION1
84:
85: FROM HR_ORGANIZATION_UNITS o1
86: ,HR_ORGANIZATION_INFORMATION hoi1
87: ,HR_ORGANIZATION_INFORMATION hoi2
88: ,HR_ORGANIZATION_INFORMATION hoi3
89: ,HR_ORGANIZATION_INFORMATION hoi4
90: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
91: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 88: ,HR_ORGANIZATION_INFORMATION hoi3

84:
85: FROM HR_ORGANIZATION_UNITS o1
86: ,HR_ORGANIZATION_INFORMATION hoi1
87: ,HR_ORGANIZATION_INFORMATION hoi2
88: ,HR_ORGANIZATION_INFORMATION hoi3
89: ,HR_ORGANIZATION_INFORMATION hoi4
90: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
91: FROM PER_ALL_ASSIGNMENTS_F ASG
92: ,HR_SOFT_CODING_KEYFLEX SCL

Line 89: ,HR_ORGANIZATION_INFORMATION hoi4

85: FROM HR_ORGANIZATION_UNITS o1
86: ,HR_ORGANIZATION_INFORMATION hoi1
87: ,HR_ORGANIZATION_INFORMATION hoi2
88: ,HR_ORGANIZATION_INFORMATION hoi3
89: ,HR_ORGANIZATION_INFORMATION hoi4
90: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
91: FROM PER_ALL_ASSIGNMENTS_F ASG
92: ,HR_SOFT_CODING_KEYFLEX SCL
93: WHERE ASG.ASSIGNMENT_ID = p_assignment_id