APPS.PAY_SE_HOLIDAY_PAY dependencies on HR_ORGANIZATION_INFORMATION

Line 35: ,HR_ORGANIZATION_INFORMATION hoi1

31:
32: /*Cursor csr_Earning_Year is
33: SELECT substr(hoi4.ORG_INFORMATION1,4,2),substr(hoi4.ORG_INFORMATION2,4,2)
34: FROM HR_ORGANIZATION_UNITS o1
35: ,HR_ORGANIZATION_INFORMATION hoi1
36: ,HR_ORGANIZATION_INFORMATION hoi2
37: ,HR_ORGANIZATION_INFORMATION hoi3
38: ,HR_ORGANIZATION_INFORMATION hoi4
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 36: ,HR_ORGANIZATION_INFORMATION hoi2

32: /*Cursor csr_Earning_Year is
33: SELECT substr(hoi4.ORG_INFORMATION1,4,2),substr(hoi4.ORG_INFORMATION2,4,2)
34: FROM HR_ORGANIZATION_UNITS o1
35: ,HR_ORGANIZATION_INFORMATION hoi1
36: ,HR_ORGANIZATION_INFORMATION hoi2
37: ,HR_ORGANIZATION_INFORMATION hoi3
38: ,HR_ORGANIZATION_INFORMATION hoi4
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
40: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 37: ,HR_ORGANIZATION_INFORMATION hoi3

33: SELECT substr(hoi4.ORG_INFORMATION1,4,2),substr(hoi4.ORG_INFORMATION2,4,2)
34: FROM HR_ORGANIZATION_UNITS o1
35: ,HR_ORGANIZATION_INFORMATION hoi1
36: ,HR_ORGANIZATION_INFORMATION hoi2
37: ,HR_ORGANIZATION_INFORMATION hoi3
38: ,HR_ORGANIZATION_INFORMATION hoi4
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
40: FROM PER_ALL_ASSIGNMENTS_F ASG
41: ,HR_SOFT_CODING_KEYFLEX SCL

Line 38: ,HR_ORGANIZATION_INFORMATION hoi4

34: FROM HR_ORGANIZATION_UNITS o1
35: ,HR_ORGANIZATION_INFORMATION hoi1
36: ,HR_ORGANIZATION_INFORMATION hoi2
37: ,HR_ORGANIZATION_INFORMATION hoi3
38: ,HR_ORGANIZATION_INFORMATION hoi4
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
40: FROM PER_ALL_ASSIGNMENTS_F ASG
41: ,HR_SOFT_CODING_KEYFLEX SCL
42: WHERE ASG.ASSIGNMENT_ID = p_assignment_id

Line 76: ,hr_organization_information hoi1

72: CURSOR csr_legal_employer_entitlement
73: IS
74: SELECT hoi4.org_information1
75: FROM hr_organization_units o1
76: ,hr_organization_information hoi1
77: ,hr_organization_information hoi2
78: ,hr_organization_information hoi3
79: ,hr_organization_information hoi4
80: , (SELECT TRIM (scl.segment2) AS org_id

Line 77: ,hr_organization_information hoi2

73: IS
74: SELECT hoi4.org_information1
75: FROM hr_organization_units o1
76: ,hr_organization_information hoi1
77: ,hr_organization_information hoi2
78: ,hr_organization_information hoi3
79: ,hr_organization_information hoi4
80: , (SELECT TRIM (scl.segment2) AS org_id
81: FROM per_all_assignments_f asg

Line 78: ,hr_organization_information hoi3

74: SELECT hoi4.org_information1
75: FROM hr_organization_units o1
76: ,hr_organization_information hoi1
77: ,hr_organization_information hoi2
78: ,hr_organization_information hoi3
79: ,hr_organization_information hoi4
80: , (SELECT TRIM (scl.segment2) AS org_id
81: FROM per_all_assignments_f asg
82: ,hr_soft_coding_keyflex scl

Line 79: ,hr_organization_information hoi4

75: FROM hr_organization_units o1
76: ,hr_organization_information hoi1
77: ,hr_organization_information hoi2
78: ,hr_organization_information hoi3
79: ,hr_organization_information hoi4
80: , (SELECT TRIM (scl.segment2) AS org_id
81: FROM per_all_assignments_f asg
82: ,hr_soft_coding_keyflex scl
83: WHERE asg.assignment_id = p_assignment_id

Line 161: ,hr_organization_information hoi1

157: IS
158: SELECT SUBSTR (hoi4.org_information1, 4, 2)
159: ,SUBSTR (hoi4.org_information2, 4, 2)
160: FROM hr_organization_units o1
161: ,hr_organization_information hoi1
162: ,hr_organization_information hoi2
163: ,hr_organization_information hoi3
164: ,hr_organization_information hoi4
165: , (SELECT TRIM (scl.segment2) AS org_id

Line 162: ,hr_organization_information hoi2

158: SELECT SUBSTR (hoi4.org_information1, 4, 2)
159: ,SUBSTR (hoi4.org_information2, 4, 2)
160: FROM hr_organization_units o1
161: ,hr_organization_information hoi1
162: ,hr_organization_information hoi2
163: ,hr_organization_information hoi3
164: ,hr_organization_information hoi4
165: , (SELECT TRIM (scl.segment2) AS org_id
166: FROM per_all_assignments_f asg

Line 163: ,hr_organization_information hoi3

159: ,SUBSTR (hoi4.org_information2, 4, 2)
160: FROM hr_organization_units o1
161: ,hr_organization_information hoi1
162: ,hr_organization_information hoi2
163: ,hr_organization_information hoi3
164: ,hr_organization_information hoi4
165: , (SELECT TRIM (scl.segment2) AS org_id
166: FROM per_all_assignments_f asg
167: ,hr_soft_coding_keyflex scl

Line 164: ,hr_organization_information hoi4

160: FROM hr_organization_units o1
161: ,hr_organization_information hoi1
162: ,hr_organization_information hoi2
163: ,hr_organization_information hoi3
164: ,hr_organization_information hoi4
165: , (SELECT TRIM (scl.segment2) AS org_id
166: FROM per_all_assignments_f asg
167: ,hr_soft_coding_keyflex scl
168: WHERE asg.assignment_id = p_assignment_id

Line 312: ,hr_organization_information hoi1

308: IS
309: SELECT SUBSTR (hoi4.org_information1, 4, 2)
310: ,SUBSTR (hoi4.org_information2, 4, 2)
311: FROM hr_organization_units o1
312: ,hr_organization_information hoi1
313: ,hr_organization_information hoi2
314: ,hr_organization_information hoi3
315: ,hr_organization_information hoi4
316: , (SELECT TRIM (scl.segment2) AS org_id

Line 313: ,hr_organization_information hoi2

309: SELECT SUBSTR (hoi4.org_information1, 4, 2)
310: ,SUBSTR (hoi4.org_information2, 4, 2)
311: FROM hr_organization_units o1
312: ,hr_organization_information hoi1
313: ,hr_organization_information hoi2
314: ,hr_organization_information hoi3
315: ,hr_organization_information hoi4
316: , (SELECT TRIM (scl.segment2) AS org_id
317: FROM per_all_assignments_f asg

Line 314: ,hr_organization_information hoi3

310: ,SUBSTR (hoi4.org_information2, 4, 2)
311: FROM hr_organization_units o1
312: ,hr_organization_information hoi1
313: ,hr_organization_information hoi2
314: ,hr_organization_information hoi3
315: ,hr_organization_information hoi4
316: , (SELECT TRIM (scl.segment2) AS org_id
317: FROM per_all_assignments_f asg
318: ,hr_soft_coding_keyflex scl

Line 315: ,hr_organization_information hoi4

311: FROM hr_organization_units o1
312: ,hr_organization_information hoi1
313: ,hr_organization_information hoi2
314: ,hr_organization_information hoi3
315: ,hr_organization_information hoi4
316: , (SELECT TRIM (scl.segment2) AS org_id
317: FROM per_all_assignments_f asg
318: ,hr_soft_coding_keyflex scl
319: WHERE asg.assignment_id = p_assignment_id

Line 460: ,HR_ORGANIZATION_INFORMATION hoi1

456:
457: /*Cursor csr_Earning_Year is
458: SELECT substr(hoi4.ORG_INFORMATION1,4,2),substr(hoi4.ORG_INFORMATION2,4,2)
459: FROM HR_ORGANIZATION_UNITS o1
460: ,HR_ORGANIZATION_INFORMATION hoi1
461: ,HR_ORGANIZATION_INFORMATION hoi2
462: ,HR_ORGANIZATION_INFORMATION hoi3
463: ,HR_ORGANIZATION_INFORMATION hoi4
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 461: ,HR_ORGANIZATION_INFORMATION hoi2

457: /*Cursor csr_Earning_Year is
458: SELECT substr(hoi4.ORG_INFORMATION1,4,2),substr(hoi4.ORG_INFORMATION2,4,2)
459: FROM HR_ORGANIZATION_UNITS o1
460: ,HR_ORGANIZATION_INFORMATION hoi1
461: ,HR_ORGANIZATION_INFORMATION hoi2
462: ,HR_ORGANIZATION_INFORMATION hoi3
463: ,HR_ORGANIZATION_INFORMATION hoi4
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
465: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 462: ,HR_ORGANIZATION_INFORMATION hoi3

458: SELECT substr(hoi4.ORG_INFORMATION1,4,2),substr(hoi4.ORG_INFORMATION2,4,2)
459: FROM HR_ORGANIZATION_UNITS o1
460: ,HR_ORGANIZATION_INFORMATION hoi1
461: ,HR_ORGANIZATION_INFORMATION hoi2
462: ,HR_ORGANIZATION_INFORMATION hoi3
463: ,HR_ORGANIZATION_INFORMATION hoi4
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
465: FROM PER_ALL_ASSIGNMENTS_F ASG
466: ,HR_SOFT_CODING_KEYFLEX SCL

Line 463: ,HR_ORGANIZATION_INFORMATION hoi4

459: FROM HR_ORGANIZATION_UNITS o1
460: ,HR_ORGANIZATION_INFORMATION hoi1
461: ,HR_ORGANIZATION_INFORMATION hoi2
462: ,HR_ORGANIZATION_INFORMATION hoi3
463: ,HR_ORGANIZATION_INFORMATION hoi4
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
465: FROM PER_ALL_ASSIGNMENTS_F ASG
466: ,HR_SOFT_CODING_KEYFLEX SCL
467: WHERE ASG.ASSIGNMENT_ID = p_assignment_id

Line 501: ,hr_organization_information hoi1

497: CURSOR csr_legal_employer_entitlement
498: IS
499: SELECT hoi4.org_information1
500: FROM hr_organization_units o1
501: ,hr_organization_information hoi1
502: ,hr_organization_information hoi2
503: ,hr_organization_information hoi3
504: ,hr_organization_information hoi4
505: , (SELECT TRIM (scl.segment2) AS org_id

Line 502: ,hr_organization_information hoi2

498: IS
499: SELECT hoi4.org_information1
500: FROM hr_organization_units o1
501: ,hr_organization_information hoi1
502: ,hr_organization_information hoi2
503: ,hr_organization_information hoi3
504: ,hr_organization_information hoi4
505: , (SELECT TRIM (scl.segment2) AS org_id
506: FROM per_all_assignments_f asg

Line 503: ,hr_organization_information hoi3

499: SELECT hoi4.org_information1
500: FROM hr_organization_units o1
501: ,hr_organization_information hoi1
502: ,hr_organization_information hoi2
503: ,hr_organization_information hoi3
504: ,hr_organization_information hoi4
505: , (SELECT TRIM (scl.segment2) AS org_id
506: FROM per_all_assignments_f asg
507: ,hr_soft_coding_keyflex scl

Line 504: ,hr_organization_information hoi4

500: FROM hr_organization_units o1
501: ,hr_organization_information hoi1
502: ,hr_organization_information hoi2
503: ,hr_organization_information hoi3
504: ,hr_organization_information hoi4
505: , (SELECT TRIM (scl.segment2) AS org_id
506: FROM per_all_assignments_f asg
507: ,hr_soft_coding_keyflex scl
508: WHERE asg.assignment_id = p_assignment_id

Line 585: ,hr_organization_information hoi1

581: WHERE ABSENCE_ATTENDANCE_TYPE_ID=csr_v_absence_type_id;*/
582: SELECT hoi4.org_information2
583: ,hoi4.org_information3
584: FROM hr_organization_units o1
585: ,hr_organization_information hoi1
586: ,hr_organization_information hoi2
587: ,hr_organization_information hoi3
588: ,hr_organization_information hoi4
589: , (SELECT TRIM (scl.segment2) AS org_id

Line 586: ,hr_organization_information hoi2

582: SELECT hoi4.org_information2
583: ,hoi4.org_information3
584: FROM hr_organization_units o1
585: ,hr_organization_information hoi1
586: ,hr_organization_information hoi2
587: ,hr_organization_information hoi3
588: ,hr_organization_information hoi4
589: , (SELECT TRIM (scl.segment2) AS org_id
590: FROM per_all_assignments_f asg

Line 587: ,hr_organization_information hoi3

583: ,hoi4.org_information3
584: FROM hr_organization_units o1
585: ,hr_organization_information hoi1
586: ,hr_organization_information hoi2
587: ,hr_organization_information hoi3
588: ,hr_organization_information hoi4
589: , (SELECT TRIM (scl.segment2) AS org_id
590: FROM per_all_assignments_f asg
591: ,hr_soft_coding_keyflex scl

Line 588: ,hr_organization_information hoi4

584: FROM hr_organization_units o1
585: ,hr_organization_information hoi1
586: ,hr_organization_information hoi2
587: ,hr_organization_information hoi3
588: ,hr_organization_information hoi4
589: , (SELECT TRIM (scl.segment2) AS org_id
590: FROM per_all_assignments_f asg
591: ,hr_soft_coding_keyflex scl
592: WHERE asg.assignment_id = p_assignment_id

Line 883: ,hr_organization_information hoi1

879: CURSOR csr_legal_employer_entitlement
880: IS
881: SELECT hoi4.org_information1
882: FROM hr_organization_units o1
883: ,hr_organization_information hoi1
884: ,hr_organization_information hoi2
885: ,hr_organization_information hoi3
886: ,hr_organization_information hoi4
887: , (SELECT TRIM (scl.segment2) AS org_id

Line 884: ,hr_organization_information hoi2

880: IS
881: SELECT hoi4.org_information1
882: FROM hr_organization_units o1
883: ,hr_organization_information hoi1
884: ,hr_organization_information hoi2
885: ,hr_organization_information hoi3
886: ,hr_organization_information hoi4
887: , (SELECT TRIM (scl.segment2) AS org_id
888: FROM per_all_assignments_f asg

Line 885: ,hr_organization_information hoi3

881: SELECT hoi4.org_information1
882: FROM hr_organization_units o1
883: ,hr_organization_information hoi1
884: ,hr_organization_information hoi2
885: ,hr_organization_information hoi3
886: ,hr_organization_information hoi4
887: , (SELECT TRIM (scl.segment2) AS org_id
888: FROM per_all_assignments_f asg
889: ,hr_soft_coding_keyflex scl

Line 886: ,hr_organization_information hoi4

882: FROM hr_organization_units o1
883: ,hr_organization_information hoi1
884: ,hr_organization_information hoi2
885: ,hr_organization_information hoi3
886: ,hr_organization_information hoi4
887: , (SELECT TRIM (scl.segment2) AS org_id
888: FROM per_all_assignments_f asg
889: ,hr_soft_coding_keyflex scl
890: WHERE asg.assignment_id = p_assignment_id

Line 1122: ,hr_organization_information hoi1

1118: CURSOR csr_legal_employer_limit
1119: IS
1120: SELECT hoi4.org_information3
1121: FROM hr_organization_units o1
1122: ,hr_organization_information hoi1
1123: ,hr_organization_information hoi2
1124: ,hr_organization_information hoi3
1125: ,hr_organization_information hoi4
1126: , (SELECT TRIM (scl.segment2) AS org_id

Line 1123: ,hr_organization_information hoi2

1119: IS
1120: SELECT hoi4.org_information3
1121: FROM hr_organization_units o1
1122: ,hr_organization_information hoi1
1123: ,hr_organization_information hoi2
1124: ,hr_organization_information hoi3
1125: ,hr_organization_information hoi4
1126: , (SELECT TRIM (scl.segment2) AS org_id
1127: FROM per_all_assignments_f asg

Line 1124: ,hr_organization_information hoi3

1120: SELECT hoi4.org_information3
1121: FROM hr_organization_units o1
1122: ,hr_organization_information hoi1
1123: ,hr_organization_information hoi2
1124: ,hr_organization_information hoi3
1125: ,hr_organization_information hoi4
1126: , (SELECT TRIM (scl.segment2) AS org_id
1127: FROM per_all_assignments_f asg
1128: ,hr_soft_coding_keyflex scl

Line 1125: ,hr_organization_information hoi4

1121: FROM hr_organization_units o1
1122: ,hr_organization_information hoi1
1123: ,hr_organization_information hoi2
1124: ,hr_organization_information hoi3
1125: ,hr_organization_information hoi4
1126: , (SELECT TRIM (scl.segment2) AS org_id
1127: FROM per_all_assignments_f asg
1128: ,hr_soft_coding_keyflex scl
1129: WHERE asg.assignment_id = p_assignment_id

Line 1166: ,hr_organization_information hoi1

1162: CURSOR csr_legal_employer_entitlement
1163: IS
1164: SELECT hoi4.org_information1
1165: FROM hr_organization_units o1
1166: ,hr_organization_information hoi1
1167: ,hr_organization_information hoi2
1168: ,hr_organization_information hoi3
1169: ,hr_organization_information hoi4
1170: , (SELECT TRIM (scl.segment2) AS org_id

Line 1167: ,hr_organization_information hoi2

1163: IS
1164: SELECT hoi4.org_information1
1165: FROM hr_organization_units o1
1166: ,hr_organization_information hoi1
1167: ,hr_organization_information hoi2
1168: ,hr_organization_information hoi3
1169: ,hr_organization_information hoi4
1170: , (SELECT TRIM (scl.segment2) AS org_id
1171: FROM per_all_assignments_f asg

Line 1168: ,hr_organization_information hoi3

1164: SELECT hoi4.org_information1
1165: FROM hr_organization_units o1
1166: ,hr_organization_information hoi1
1167: ,hr_organization_information hoi2
1168: ,hr_organization_information hoi3
1169: ,hr_organization_information hoi4
1170: , (SELECT TRIM (scl.segment2) AS org_id
1171: FROM per_all_assignments_f asg
1172: ,hr_soft_coding_keyflex scl

Line 1169: ,hr_organization_information hoi4

1165: FROM hr_organization_units o1
1166: ,hr_organization_information hoi1
1167: ,hr_organization_information hoi2
1168: ,hr_organization_information hoi3
1169: ,hr_organization_information hoi4
1170: , (SELECT TRIM (scl.segment2) AS org_id
1171: FROM per_all_assignments_f asg
1172: ,hr_soft_coding_keyflex scl
1173: WHERE asg.assignment_id = p_assignment_id

Line 1270: ,hr_organization_information hoi1

1266: IS
1267: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1268: ,SUBSTR (hoi2.org_information2, 4, 2)
1269: FROM hr_organization_units o1
1270: ,hr_organization_information hoi1
1271: ,hr_organization_information hoi2
1272: WHERE hoi1.organization_id = o1.organization_id
1273: AND hoi1.organization_id = p_tax_unit_id --3134
1274: AND hoi1.org_information_context = 'CLASS'

Line 1271: ,hr_organization_information hoi2

1267: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1268: ,SUBSTR (hoi2.org_information2, 4, 2)
1269: FROM hr_organization_units o1
1270: ,hr_organization_information hoi1
1271: ,hr_organization_information hoi2
1272: WHERE hoi1.organization_id = o1.organization_id
1273: AND hoi1.organization_id = p_tax_unit_id --3134
1274: AND hoi1.org_information_context = 'CLASS'
1275: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1340: ,hr_organization_information hoi1

1336: IS
1337: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1338: ,SUBSTR (hoi2.org_information2, 4, 2)
1339: FROM hr_organization_units o1
1340: ,hr_organization_information hoi1
1341: ,hr_organization_information hoi2
1342: WHERE hoi1.organization_id = o1.organization_id
1343: AND hoi1.organization_id = p_tax_unit_id --3134
1344: AND hoi1.org_information_context = 'CLASS'

Line 1341: ,hr_organization_information hoi2

1337: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1338: ,SUBSTR (hoi2.org_information2, 4, 2)
1339: FROM hr_organization_units o1
1340: ,hr_organization_information hoi1
1341: ,hr_organization_information hoi2
1342: WHERE hoi1.organization_id = o1.organization_id
1343: AND hoi1.organization_id = p_tax_unit_id --3134
1344: AND hoi1.org_information_context = 'CLASS'
1345: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1507: UPDATE hr_organization_information

1503: FUNCTION update_entitlement_ran (p_tax_unit_id IN NUMBER)
1504: RETURN NUMBER
1505: IS
1506: BEGIN
1507: UPDATE hr_organization_information
1508: SET org_information5 = 'Y'
1509: WHERE org_information_id =
1510: (SELECT hoi2.org_information_id
1511: FROM hr_organization_units o1

Line 1512: ,hr_organization_information hoi1

1508: SET org_information5 = 'Y'
1509: WHERE org_information_id =
1510: (SELECT hoi2.org_information_id
1511: FROM hr_organization_units o1
1512: ,hr_organization_information hoi1
1513: ,hr_organization_information hoi2
1514: WHERE hoi1.organization_id = o1.organization_id
1515: AND hoi1.organization_id = p_tax_unit_id --3134
1516: AND hoi1.org_information_context = 'CLASS'

Line 1513: ,hr_organization_information hoi2

1509: WHERE org_information_id =
1510: (SELECT hoi2.org_information_id
1511: FROM hr_organization_units o1
1512: ,hr_organization_information hoi1
1513: ,hr_organization_information hoi2
1514: WHERE hoi1.organization_id = o1.organization_id
1515: AND hoi1.organization_id = p_tax_unit_id --3134
1516: AND hoi1.org_information_context = 'CLASS'
1517: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1553: ,hr_organization_information hoi1

1549: IS
1550: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1551: ,SUBSTR (hoi2.org_information2, 4, 2)
1552: FROM hr_organization_units o1
1553: ,hr_organization_information hoi1
1554: ,hr_organization_information hoi2
1555: WHERE hoi1.organization_id = o1.organization_id
1556: AND hoi1.organization_id = p_tax_unit_id
1557: AND hoi1.org_information_context = 'CLASS'

Line 1554: ,hr_organization_information hoi2

1550: SELECT SUBSTR (hoi2.org_information1, 4, 2)
1551: ,SUBSTR (hoi2.org_information2, 4, 2)
1552: FROM hr_organization_units o1
1553: ,hr_organization_information hoi1
1554: ,hr_organization_information hoi2
1555: WHERE hoi1.organization_id = o1.organization_id
1556: AND hoi1.organization_id = p_tax_unit_id
1557: AND hoi1.org_information_context = 'CLASS'
1558: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1745: ,hr_organization_information hoi1

1741: IS
1742: SELECT hoi4.org_information2
1743: ,hoi4.org_information3
1744: FROM hr_organization_units o1
1745: ,hr_organization_information hoi1
1746: ,hr_organization_information hoi2
1747: ,hr_organization_information hoi3
1748: ,hr_organization_information hoi4
1749: , (SELECT TRIM (scl.segment2) AS org_id

Line 1746: ,hr_organization_information hoi2

1742: SELECT hoi4.org_information2
1743: ,hoi4.org_information3
1744: FROM hr_organization_units o1
1745: ,hr_organization_information hoi1
1746: ,hr_organization_information hoi2
1747: ,hr_organization_information hoi3
1748: ,hr_organization_information hoi4
1749: , (SELECT TRIM (scl.segment2) AS org_id
1750: FROM per_all_assignments_f asg

Line 1747: ,hr_organization_information hoi3

1743: ,hoi4.org_information3
1744: FROM hr_organization_units o1
1745: ,hr_organization_information hoi1
1746: ,hr_organization_information hoi2
1747: ,hr_organization_information hoi3
1748: ,hr_organization_information hoi4
1749: , (SELECT TRIM (scl.segment2) AS org_id
1750: FROM per_all_assignments_f asg
1751: ,hr_soft_coding_keyflex scl

Line 1748: ,hr_organization_information hoi4

1744: FROM hr_organization_units o1
1745: ,hr_organization_information hoi1
1746: ,hr_organization_information hoi2
1747: ,hr_organization_information hoi3
1748: ,hr_organization_information hoi4
1749: , (SELECT TRIM (scl.segment2) AS org_id
1750: FROM per_all_assignments_f asg
1751: ,hr_soft_coding_keyflex scl
1752: WHERE asg.assignment_id = p_assignment_id

Line 1776: ,hr_organization_information hoi1

1772: CURSOR csr_earning_year
1773: IS
1774: SELECT SUBSTR (hoi2.org_information2, 4, 2)
1775: FROM hr_organization_units o1
1776: ,hr_organization_information hoi1
1777: ,hr_organization_information hoi2
1778: WHERE hoi1.organization_id = o1.organization_id
1779: AND hoi1.organization_id = p_tax_unit_id
1780: AND hoi1.org_information_context = 'CLASS'

Line 1777: ,hr_organization_information hoi2

1773: IS
1774: SELECT SUBSTR (hoi2.org_information2, 4, 2)
1775: FROM hr_organization_units o1
1776: ,hr_organization_information hoi1
1777: ,hr_organization_information hoi2
1778: WHERE hoi1.organization_id = o1.organization_id
1779: AND hoi1.organization_id = p_tax_unit_id
1780: AND hoi1.org_information_context = 'CLASS'
1781: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1817: ,hr_organization_information hoi1

1813: CURSOR csr_legal_employer_entitlement
1814: IS
1815: SELECT hoi4.org_information1
1816: FROM hr_organization_units o1
1817: ,hr_organization_information hoi1
1818: ,hr_organization_information hoi2
1819: ,hr_organization_information hoi3
1820: ,hr_organization_information hoi4
1821: , (SELECT TRIM (scl.segment2) AS org_id

Line 1818: ,hr_organization_information hoi2

1814: IS
1815: SELECT hoi4.org_information1
1816: FROM hr_organization_units o1
1817: ,hr_organization_information hoi1
1818: ,hr_organization_information hoi2
1819: ,hr_organization_information hoi3
1820: ,hr_organization_information hoi4
1821: , (SELECT TRIM (scl.segment2) AS org_id
1822: FROM per_all_assignments_f asg

Line 1819: ,hr_organization_information hoi3

1815: SELECT hoi4.org_information1
1816: FROM hr_organization_units o1
1817: ,hr_organization_information hoi1
1818: ,hr_organization_information hoi2
1819: ,hr_organization_information hoi3
1820: ,hr_organization_information hoi4
1821: , (SELECT TRIM (scl.segment2) AS org_id
1822: FROM per_all_assignments_f asg
1823: ,hr_soft_coding_keyflex scl

Line 1820: ,hr_organization_information hoi4

1816: FROM hr_organization_units o1
1817: ,hr_organization_information hoi1
1818: ,hr_organization_information hoi2
1819: ,hr_organization_information hoi3
1820: ,hr_organization_information hoi4
1821: , (SELECT TRIM (scl.segment2) AS org_id
1822: FROM per_all_assignments_f asg
1823: ,hr_soft_coding_keyflex scl
1824: WHERE asg.assignment_id = p_assignment_id

Line 2029: ,hr_organization_information hoi1

2025: IS
2026: SELECT hoi4.org_information2
2027: ,hoi4.org_information3
2028: FROM hr_organization_units o1
2029: ,hr_organization_information hoi1
2030: ,hr_organization_information hoi2
2031: ,hr_organization_information hoi3
2032: ,hr_organization_information hoi4
2033: , (SELECT TRIM (scl.segment2) AS org_id

Line 2030: ,hr_organization_information hoi2

2026: SELECT hoi4.org_information2
2027: ,hoi4.org_information3
2028: FROM hr_organization_units o1
2029: ,hr_organization_information hoi1
2030: ,hr_organization_information hoi2
2031: ,hr_organization_information hoi3
2032: ,hr_organization_information hoi4
2033: , (SELECT TRIM (scl.segment2) AS org_id
2034: FROM per_all_assignments_f asg

Line 2031: ,hr_organization_information hoi3

2027: ,hoi4.org_information3
2028: FROM hr_organization_units o1
2029: ,hr_organization_information hoi1
2030: ,hr_organization_information hoi2
2031: ,hr_organization_information hoi3
2032: ,hr_organization_information hoi4
2033: , (SELECT TRIM (scl.segment2) AS org_id
2034: FROM per_all_assignments_f asg
2035: ,hr_soft_coding_keyflex scl

Line 2032: ,hr_organization_information hoi4

2028: FROM hr_organization_units o1
2029: ,hr_organization_information hoi1
2030: ,hr_organization_information hoi2
2031: ,hr_organization_information hoi3
2032: ,hr_organization_information hoi4
2033: , (SELECT TRIM (scl.segment2) AS org_id
2034: FROM per_all_assignments_f asg
2035: ,hr_soft_coding_keyflex scl
2036: WHERE asg.assignment_id = p_assignment_id

Line 2060: ,hr_organization_information hoi1

2056: CURSOR csr_earning_year
2057: IS
2058: SELECT SUBSTR (hoi2.org_information2, 4, 2)
2059: FROM hr_organization_units o1
2060: ,hr_organization_information hoi1
2061: ,hr_organization_information hoi2
2062: WHERE hoi1.organization_id = o1.organization_id
2063: AND hoi1.organization_id = p_tax_unit_id
2064: AND hoi1.org_information_context = 'CLASS'

Line 2061: ,hr_organization_information hoi2

2057: IS
2058: SELECT SUBSTR (hoi2.org_information2, 4, 2)
2059: FROM hr_organization_units o1
2060: ,hr_organization_information hoi1
2061: ,hr_organization_information hoi2
2062: WHERE hoi1.organization_id = o1.organization_id
2063: AND hoi1.organization_id = p_tax_unit_id
2064: AND hoi1.org_information_context = 'CLASS'
2065: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 2101: ,hr_organization_information hoi1

2097: CURSOR csr_legal_employer_entitlement
2098: IS
2099: SELECT hoi4.org_information1
2100: FROM hr_organization_units o1
2101: ,hr_organization_information hoi1
2102: ,hr_organization_information hoi2
2103: ,hr_organization_information hoi3
2104: ,hr_organization_information hoi4
2105: , (SELECT TRIM (scl.segment2) AS org_id

Line 2102: ,hr_organization_information hoi2

2098: IS
2099: SELECT hoi4.org_information1
2100: FROM hr_organization_units o1
2101: ,hr_organization_information hoi1
2102: ,hr_organization_information hoi2
2103: ,hr_organization_information hoi3
2104: ,hr_organization_information hoi4
2105: , (SELECT TRIM (scl.segment2) AS org_id
2106: FROM per_all_assignments_f asg

Line 2103: ,hr_organization_information hoi3

2099: SELECT hoi4.org_information1
2100: FROM hr_organization_units o1
2101: ,hr_organization_information hoi1
2102: ,hr_organization_information hoi2
2103: ,hr_organization_information hoi3
2104: ,hr_organization_information hoi4
2105: , (SELECT TRIM (scl.segment2) AS org_id
2106: FROM per_all_assignments_f asg
2107: ,hr_soft_coding_keyflex scl

Line 2104: ,hr_organization_information hoi4

2100: FROM hr_organization_units o1
2101: ,hr_organization_information hoi1
2102: ,hr_organization_information hoi2
2103: ,hr_organization_information hoi3
2104: ,hr_organization_information hoi4
2105: , (SELECT TRIM (scl.segment2) AS org_id
2106: FROM per_all_assignments_f asg
2107: ,hr_soft_coding_keyflex scl
2108: WHERE asg.assignment_id = p_assignment_id

Line 2266: ,hr_organization_information hoi3

2262: IS
2263: SELECT SUBSTR (hoi4.org_information1, 4, 2)
2264: ,SUBSTR (hoi4.org_information2, 4, 2)
2265: FROM hr_organization_units o1
2266: ,hr_organization_information hoi3
2267: ,hr_organization_information hoi4
2268: WHERE o1.business_group_id = l_business_group_id
2269: AND o1.organization_id = hoi3.organization_id
2270: AND hoi3.organization_id = p_tax_unit_id

Line 2267: ,hr_organization_information hoi4

2263: SELECT SUBSTR (hoi4.org_information1, 4, 2)
2264: ,SUBSTR (hoi4.org_information2, 4, 2)
2265: FROM hr_organization_units o1
2266: ,hr_organization_information hoi3
2267: ,hr_organization_information hoi4
2268: WHERE o1.business_group_id = l_business_group_id
2269: AND o1.organization_id = hoi3.organization_id
2270: AND hoi3.organization_id = p_tax_unit_id
2271: AND hoi3.org_information_context = 'CLASS'

Line 2422: ,hr_organization_information hoi3

2418: CURSOR csr_legal_employer_entitlement
2419: IS
2420: SELECT hoi4.org_information1
2421: FROM hr_organization_units o1
2422: ,hr_organization_information hoi3
2423: ,hr_organization_information hoi4
2424: WHERE o1.business_group_id = l_business_group_id
2425: AND o1.organization_id = hoi3.organization_id
2426: AND hoi3.organization_id = p_tax_unit_id

Line 2423: ,hr_organization_information hoi4

2419: IS
2420: SELECT hoi4.org_information1
2421: FROM hr_organization_units o1
2422: ,hr_organization_information hoi3
2423: ,hr_organization_information hoi4
2424: WHERE o1.business_group_id = l_business_group_id
2425: AND o1.organization_id = hoi3.organization_id
2426: AND hoi3.organization_id = p_tax_unit_id
2427: AND hoi3.org_information_context = 'CLASS'

Line 2538: ,hr_organization_information hoi3

2534: CURSOR csr_legal_employer_entitlement
2535: IS
2536: SELECT hoi4.org_information1
2537: FROM hr_organization_units o1
2538: ,hr_organization_information hoi3
2539: ,hr_organization_information hoi4
2540: WHERE o1.business_group_id = l_business_group_id
2541: AND o1.organization_id = hoi3.organization_id
2542: AND hoi3.organization_id = p_tax_unit_id

Line 2539: ,hr_organization_information hoi4

2535: IS
2536: SELECT hoi4.org_information1
2537: FROM hr_organization_units o1
2538: ,hr_organization_information hoi3
2539: ,hr_organization_information hoi4
2540: WHERE o1.business_group_id = l_business_group_id
2541: AND o1.organization_id = hoi3.organization_id
2542: AND hoi3.organization_id = p_tax_unit_id
2543: AND hoi3.org_information_context = 'CLASS'

Line 2595: ,hr_organization_information hoi3

2591: IS
2592: SELECT hoi4.org_information2
2593: ,hoi4.org_information3
2594: FROM hr_organization_units o1
2595: ,hr_organization_information hoi3
2596: ,hr_organization_information hoi4
2597: WHERE o1.business_group_id = l_business_group_id
2598: AND hoi3.organization_id = o1.organization_id
2599: AND hoi3.organization_id = p_tax_unit_id

Line 2596: ,hr_organization_information hoi4

2592: SELECT hoi4.org_information2
2593: ,hoi4.org_information3
2594: FROM hr_organization_units o1
2595: ,hr_organization_information hoi3
2596: ,hr_organization_information hoi4
2597: WHERE o1.business_group_id = l_business_group_id
2598: AND hoi3.organization_id = o1.organization_id
2599: AND hoi3.organization_id = p_tax_unit_id
2600: AND hoi3.org_information_context = 'CLASS'

Line 2781: ,hr_organization_information hoi1

2777: IS
2778: SELECT SUBSTR (hoi2.org_information1, 4, 2)
2779: ,SUBSTR (hoi2.org_information2, 4, 2)
2780: FROM hr_organization_units o1
2781: ,hr_organization_information hoi1
2782: ,hr_organization_information hoi2
2783: WHERE hoi1.organization_id = o1.organization_id
2784: AND hoi1.organization_id = p_tax_unit_id --3134
2785: AND hoi1.org_information_context = 'CLASS'

Line 2782: ,hr_organization_information hoi2

2778: SELECT SUBSTR (hoi2.org_information1, 4, 2)
2779: ,SUBSTR (hoi2.org_information2, 4, 2)
2780: FROM hr_organization_units o1
2781: ,hr_organization_information hoi1
2782: ,hr_organization_information hoi2
2783: WHERE hoi1.organization_id = o1.organization_id
2784: AND hoi1.organization_id = p_tax_unit_id --3134
2785: AND hoi1.org_information_context = 'CLASS'
2786: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 2859: ,hr_organization_information hoi3

2855: CURSOR csr_get_concidental
2856: IS
2857: SELECT hoi4.org_information6
2858: FROM hr_organization_units o1
2859: ,hr_organization_information hoi3
2860: ,hr_organization_information hoi4
2861: WHERE o1.business_group_id = p_business_group_id
2862: AND o1.organization_id = hoi3.organization_id
2863: AND hoi3.organization_id = p_tax_unit_id

Line 2860: ,hr_organization_information hoi4

2856: IS
2857: SELECT hoi4.org_information6
2858: FROM hr_organization_units o1
2859: ,hr_organization_information hoi3
2860: ,hr_organization_information hoi4
2861: WHERE o1.business_group_id = p_business_group_id
2862: AND o1.organization_id = hoi3.organization_id
2863: AND hoi3.organization_id = p_tax_unit_id
2864: AND hoi3.org_information_context = 'CLASS'

Line 3020: ,hr_organization_information hoi3

3016: IS
3017: SELECT SUBSTR (hoi4.org_information1, 4, 2)
3018: ,SUBSTR (hoi4.org_information2, 4, 2)
3019: FROM hr_organization_units o1
3020: ,hr_organization_information hoi3
3021: ,hr_organization_information hoi4
3022: WHERE o1.business_group_id = l_business_group_id
3023: AND o1.organization_id = hoi3.organization_id
3024: AND hoi3.organization_id = p_tax_unit_id

Line 3021: ,hr_organization_information hoi4

3017: SELECT SUBSTR (hoi4.org_information1, 4, 2)
3018: ,SUBSTR (hoi4.org_information2, 4, 2)
3019: FROM hr_organization_units o1
3020: ,hr_organization_information hoi3
3021: ,hr_organization_information hoi4
3022: WHERE o1.business_group_id = l_business_group_id
3023: AND o1.organization_id = hoi3.organization_id
3024: AND hoi3.organization_id = p_tax_unit_id
3025: AND hoi3.org_information_context = 'CLASS'

Line 3250: ,hr_organization_information hoi3

3246: CURSOR csr_legal_employer_entitlement
3247: IS
3248: SELECT hoi4.org_information2
3249: FROM hr_organization_units o1
3250: ,hr_organization_information hoi3
3251: ,hr_organization_information hoi4
3252: WHERE o1.business_group_id = p_business_group_id
3253: AND o1.organization_id = hoi3.organization_id
3254: AND hoi3.organization_id = p_tax_unit_id

Line 3251: ,hr_organization_information hoi4

3247: IS
3248: SELECT hoi4.org_information2
3249: FROM hr_organization_units o1
3250: ,hr_organization_information hoi3
3251: ,hr_organization_information hoi4
3252: WHERE o1.business_group_id = p_business_group_id
3253: AND o1.organization_id = hoi3.organization_id
3254: AND hoi3.organization_id = p_tax_unit_id
3255: AND hoi3.org_information_context = 'CLASS'

Line 3605: ,hr_organization_information hoi1

3601: IS
3602: SELECT SUBSTR (hoi2.org_information1, 4, 2)
3603: ,SUBSTR (hoi2.org_information2, 4, 2)
3604: FROM hr_organization_units o1
3605: ,hr_organization_information hoi1
3606: ,hr_organization_information hoi2
3607: WHERE hoi1.organization_id = o1.organization_id
3608: AND hoi1.organization_id = p_tax_unit_id --3134
3609: AND hoi1.org_information_context = 'CLASS'

Line 3606: ,hr_organization_information hoi2

3602: SELECT SUBSTR (hoi2.org_information1, 4, 2)
3603: ,SUBSTR (hoi2.org_information2, 4, 2)
3604: FROM hr_organization_units o1
3605: ,hr_organization_information hoi1
3606: ,hr_organization_information hoi2
3607: WHERE hoi1.organization_id = o1.organization_id
3608: AND hoi1.organization_id = p_tax_unit_id --3134
3609: AND hoi1.org_information_context = 'CLASS'
3610: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'