APPS.PAY_SE_INCOME_STATEMENT dependencies on HR_ORGANIZATION_INFORMATION

Line 311: ,hr_organization_information hoi

307: ,hoi1.org_information2 "MP_DEPARTMENT"
308: ,hoi1.org_information3 "MEDIUM_IDENTITY"
309: ,hoi1.org_information4 "PROGRAM"
310: FROM hr_all_organization_units o
311: ,hr_organization_information hoi
312: ,hr_organization_information hoi1
313: WHERE o.business_group_id = g_business_group_id
314: AND o.organization_id = hoi.organization_id
315: AND hoi.org_information_context = 'CLASS'

Line 312: ,hr_organization_information hoi1

308: ,hoi1.org_information3 "MEDIUM_IDENTITY"
309: ,hoi1.org_information4 "PROGRAM"
310: FROM hr_all_organization_units o
311: ,hr_organization_information hoi
312: ,hr_organization_information hoi1
313: WHERE o.business_group_id = g_business_group_id
314: AND o.organization_id = hoi.organization_id
315: AND hoi.org_information_context = 'CLASS'
316: AND hoi.org_information1 = 'SE_INC_STMT_PROVIDER'

Line 324: csr_v_media_provider_id hr_organization_information.organization_id%TYPE

320:
321: lr_media_provider_details csr_media_provider_details%ROWTYPE;
322:
323: CURSOR csr_org_contacts (
324: csr_v_media_provider_id hr_organization_information.organization_id%TYPE
325: ,csr_v_type hr_organization_information.org_information1%TYPE
326: )
327: IS
328: SELECT hoi22.org_information1

Line 325: ,csr_v_type hr_organization_information.org_information1%TYPE

321: lr_media_provider_details csr_media_provider_details%ROWTYPE;
322:
323: CURSOR csr_org_contacts (
324: csr_v_media_provider_id hr_organization_information.organization_id%TYPE
325: ,csr_v_type hr_organization_information.org_information1%TYPE
326: )
327: IS
328: SELECT hoi22.org_information1
329: ,hoi22.org_information2

Line 332: FROM hr_organization_information hoi11

328: SELECT hoi22.org_information1
329: ,hoi22.org_information2
330: ,hoi22.org_information3
331: ,hoi22.org_information_id
332: FROM hr_organization_information hoi11
333: ,hr_organization_information hoi22
334: WHERE hoi11.organization_id = csr_v_media_provider_id
335: AND hoi11.org_information_context = 'CLASS'
336: AND hoi11.org_information1 = 'SE_INC_STMT_PROVIDER'

Line 333: ,hr_organization_information hoi22

329: ,hoi22.org_information2
330: ,hoi22.org_information3
331: ,hoi22.org_information_id
332: FROM hr_organization_information hoi11
333: ,hr_organization_information hoi22
334: WHERE hoi11.organization_id = csr_v_media_provider_id
335: AND hoi11.org_information_context = 'CLASS'
336: AND hoi11.org_information1 = 'SE_INC_STMT_PROVIDER'
337: AND hoi22.organization_id = hoi11.organization_id

Line 346: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

342:
343: lr_org_contacts csr_org_contacts%ROWTYPE;
344:
345: CURSOR csr_legal_employer_details (
346: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
347: ,csr_v_media_provider_id hr_organization_information.organization_id%TYPE
348: )
349: IS
350: /* select o1.NAME legal_employer_name

Line 347: ,csr_v_media_provider_id hr_organization_information.organization_id%TYPE

343: lr_org_contacts csr_org_contacts%ROWTYPE;
344:
345: CURSOR csr_legal_employer_details (
346: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
347: ,csr_v_media_provider_id hr_organization_information.organization_id%TYPE
348: )
349: IS
350: /* select o1.NAME legal_employer_name
351: , hoi2.org_information2 org_number

Line 354: , hr_organization_information hoi1

350: /* select o1.NAME legal_employer_name
351: , hoi2.org_information2 org_number
352: , hoi1.organization_id legal_id
353: FROM hr_organization_units o1
354: , hr_organization_information hoi1
355: , hr_organization_information hoi2
356: , hr_organization_units o2
357: , hr_organization_information hoi3
358: WHERE o1.business_group_id = g_business_group_id

Line 355: , hr_organization_information hoi2

351: , hoi2.org_information2 org_number
352: , hoi1.organization_id legal_id
353: FROM hr_organization_units o1
354: , hr_organization_information hoi1
355: , hr_organization_information hoi2
356: , hr_organization_units o2
357: , hr_organization_information hoi3
358: WHERE o1.business_group_id = g_business_group_id
359: AND hoi1.organization_id = o1.organization_id

Line 357: , hr_organization_information hoi3

353: FROM hr_organization_units o1
354: , hr_organization_information hoi1
355: , hr_organization_information hoi2
356: , hr_organization_units o2
357: , hr_organization_information hoi3
358: WHERE o1.business_group_id = g_business_group_id
359: AND hoi1.organization_id = o1.organization_id
360: AND hoi1.organization_id = NVL(csr_v_legal_employer_id,hoi1.organization_id)
361: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 373: ,hr_organization_information hoi1

369: ,o1.location_id
370: ,hoi2.org_information2 org_number
371: ,hoi1.organization_id legal_id
372: FROM hr_organization_units o1
373: ,hr_organization_information hoi1
374: ,hr_organization_information hoi2
375: ,hr_organization_information hoi3
376: WHERE o1.business_group_id = g_business_group_id
377: AND hoi1.organization_id = o1.organization_id

Line 374: ,hr_organization_information hoi2

370: ,hoi2.org_information2 org_number
371: ,hoi1.organization_id legal_id
372: FROM hr_organization_units o1
373: ,hr_organization_information hoi1
374: ,hr_organization_information hoi2
375: ,hr_organization_information hoi3
376: WHERE o1.business_group_id = g_business_group_id
377: AND hoi1.organization_id = o1.organization_id
378: AND hoi1.organization_id =

Line 375: ,hr_organization_information hoi3

371: ,hoi1.organization_id legal_id
372: FROM hr_organization_units o1
373: ,hr_organization_information hoi1
374: ,hr_organization_information hoi2
375: ,hr_organization_information hoi3
376: WHERE o1.business_group_id = g_business_group_id
377: AND hoi1.organization_id = o1.organization_id
378: AND hoi1.organization_id =
379: NVL (csr_v_legal_employer_id, hoi1.organization_id)

Line 415: FROM hr_organization_information

411:
412: CURSOR csr_post_header
413: IS
414: SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3
415: FROM hr_organization_information
416: WHERE organization_id = g_business_group_id
417: AND org_information_context = 'SE_POST_HEADER_INFO';
418:
419: lr_post_header csr_post_header%ROWTYPE;

Line 856: ,hr_organization_information hoi1

852: -- AND as1.effective_end_date
853: AND act.tax_unit_id IN (
854: SELECT o.organization_id
855: FROM hr_all_organization_units o
856: ,hr_organization_information hoi1
857: ,hr_organization_information hoi2
858: WHERE o.business_group_id = g_business_group_id
859: AND hoi1.organization_id = o.organization_id
860: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 857: ,hr_organization_information hoi2

853: AND act.tax_unit_id IN (
854: SELECT o.organization_id
855: FROM hr_all_organization_units o
856: ,hr_organization_information hoi1
857: ,hr_organization_information hoi2
858: WHERE o.business_group_id = g_business_group_id
859: AND hoi1.organization_id = o.organization_id
860: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
861: AND hoi1.org_information_context = 'CLASS'

Line 888: l_pension_type hr_organization_information.org_information1%TYPE;

884: l_count NUMBER := 0;
885: l_prev_prepay NUMBER := 0;
886: l_canonical_start_date DATE;
887: l_canonical_end_date DATE;
888: l_pension_type hr_organization_information.org_information1%TYPE;
889: l_prepay_action_id NUMBER;
890: l_actid NUMBER;
891: l_assignment_id NUMBER;
892: l_action_sequence NUMBER;

Line 1415: ,hr_organization_information hoi1

1411: CURSOR csr_get_all_legal_employer_id
1412: IS
1413: SELECT o.organization_id
1414: FROM hr_all_organization_units o
1415: ,hr_organization_information hoi1
1416: ,hr_organization_information hoi2
1417: WHERE o.business_group_id = g_business_group_id
1418: AND hoi1.organization_id = o.organization_id
1419: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1416: ,hr_organization_information hoi2

1412: IS
1413: SELECT o.organization_id
1414: FROM hr_all_organization_units o
1415: ,hr_organization_information hoi1
1416: ,hr_organization_information hoi2
1417: WHERE o.business_group_id = g_business_group_id
1418: AND hoi1.organization_id = o.organization_id
1419: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1420: AND hoi1.org_information_context = 'CLASS'

Line 1434: , hr_organization_information hoi1

1430: /* CURSOR csr_get_all_Legal_employer_id
1431: IS
1432: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1433: FROM hr_all_organization_units o
1434: , hr_organization_information hoi1
1435: , hr_organization_information hoi2
1436: , hr_organization_information hoi3
1437: WHERE o.business_group_id = g_business_group_id
1438: AND hoi1.organization_id = o.organization_id

Line 1435: , hr_organization_information hoi2

1431: IS
1432: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1433: FROM hr_all_organization_units o
1434: , hr_organization_information hoi1
1435: , hr_organization_information hoi2
1436: , hr_organization_information hoi3
1437: WHERE o.business_group_id = g_business_group_id
1438: AND hoi1.organization_id = o.organization_id
1439: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1436: , hr_organization_information hoi3

1432: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1433: FROM hr_all_organization_units o
1434: , hr_organization_information hoi1
1435: , hr_organization_information hoi2
1436: , hr_organization_information hoi3
1437: WHERE o.business_group_id = g_business_group_id
1438: AND hoi1.organization_id = o.organization_id
1439: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1440: AND hoi1.org_information_context = 'CLASS'

Line 1453: , hr_organization_information hoi1

1449: CURSOR csr_get_all_info(csr_v_LE_id NUMBER)
1450: IS
1451: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1452: FROM hr_all_organization_units o
1453: , hr_organization_information hoi1
1454: , hr_organization_information hoi3
1455: WHERE o.business_group_id = g_business_group_id
1456: AND hoi1.organization_id = o.organization_id
1457: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1454: , hr_organization_information hoi3

1450: IS
1451: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1452: FROM hr_all_organization_units o
1453: , hr_organization_information hoi1
1454: , hr_organization_information hoi3
1455: WHERE o.business_group_id = g_business_group_id
1456: AND hoi1.organization_id = o.organization_id
1457: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1458: AND hoi1.org_information_context = 'CLASS'

Line 1470: ,hr_organization_information hoi1

1466: SELECT o.organization_id
1467: ,hoi3.org_information1
1468: ,hoi3.org_information2
1469: FROM hr_all_organization_units o
1470: ,hr_organization_information hoi1
1471: ,hr_organization_information hoi3
1472: WHERE o.business_group_id = g_business_group_id
1473: AND hoi1.organization_id = o.organization_id
1474: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1471: ,hr_organization_information hoi3

1467: ,hoi3.org_information1
1468: ,hoi3.org_information2
1469: FROM hr_all_organization_units o
1470: ,hr_organization_information hoi1
1471: ,hr_organization_information hoi3
1472: WHERE o.business_group_id = g_business_group_id
1473: AND hoi1.organization_id = o.organization_id
1474: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1475: AND hoi1.org_information_context = 'CLASS'

Line 2022: ,hr_organization_information hoi1

2018: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2019: AND scl.segment2 IN (
2020: SELECT o1.organization_id
2021: FROM hr_organization_units o1
2022: ,hr_organization_information hoi1
2023: ,hr_organization_information hoi2
2024: ,hr_organization_information hoi3
2025: WHERE o1.business_group_id = g_business_group_id
2026: AND hoi1.organization_id = o1.organization_id

Line 2023: ,hr_organization_information hoi2

2019: AND scl.segment2 IN (
2020: SELECT o1.organization_id
2021: FROM hr_organization_units o1
2022: ,hr_organization_information hoi1
2023: ,hr_organization_information hoi2
2024: ,hr_organization_information hoi3
2025: WHERE o1.business_group_id = g_business_group_id
2026: AND hoi1.organization_id = o1.organization_id
2027: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2024: ,hr_organization_information hoi3

2020: SELECT o1.organization_id
2021: FROM hr_organization_units o1
2022: ,hr_organization_information hoi1
2023: ,hr_organization_information hoi2
2024: ,hr_organization_information hoi3
2025: WHERE o1.business_group_id = g_business_group_id
2026: AND hoi1.organization_id = o1.organization_id
2027: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
2028: AND hoi1.org_information_context = 'CLASS'

Line 2067: csr_v_organization_id hr_organization_information.organization_id%TYPE

2063: lr_get_segment2 csr_get_segment2%ROWTYPE;
2064:
2065: -- Cursor to pick up LEGAL EMPLOYER
2066: CURSOR csr_find_legal_employer (
2067: csr_v_organization_id hr_organization_information.organization_id%TYPE
2068: )
2069: IS
2070: SELECT hoi3.organization_id legal_id
2071: FROM hr_all_organization_units o1

Line 2072: ,hr_organization_information hoi1

2068: )
2069: IS
2070: SELECT hoi3.organization_id legal_id
2071: FROM hr_all_organization_units o1
2072: ,hr_organization_information hoi1
2073: ,hr_organization_information hoi2
2074: ,hr_organization_information hoi3
2075: WHERE o1.business_group_id = g_business_group_id
2076: AND hoi1.organization_id = o1.organization_id

Line 2073: ,hr_organization_information hoi2

2069: IS
2070: SELECT hoi3.organization_id legal_id
2071: FROM hr_all_organization_units o1
2072: ,hr_organization_information hoi1
2073: ,hr_organization_information hoi2
2074: ,hr_organization_information hoi3
2075: WHERE o1.business_group_id = g_business_group_id
2076: AND hoi1.organization_id = o1.organization_id
2077: AND hoi1.organization_id = csr_v_organization_id

Line 2074: ,hr_organization_information hoi3

2070: SELECT hoi3.organization_id legal_id
2071: FROM hr_all_organization_units o1
2072: ,hr_organization_information hoi1
2073: ,hr_organization_information hoi2
2074: ,hr_organization_information hoi3
2075: WHERE o1.business_group_id = g_business_group_id
2076: AND hoi1.organization_id = o1.organization_id
2077: AND hoi1.organization_id = csr_v_organization_id
2078: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2090: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

2086: lr_find_legal_employer csr_find_legal_employer%ROWTYPE;
2087:
2088: -- Cursor to pick up Local Unit Details
2089: CURSOR csr_local_unit_details (
2090: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
2091: )
2092: IS
2093: SELECT o1.NAME
2094: ,hoi2.org_information2

Line 2096: ,hr_organization_information hoi1

2092: IS
2093: SELECT o1.NAME
2094: ,hoi2.org_information2
2095: FROM hr_organization_units o1
2096: ,hr_organization_information hoi1
2097: ,hr_organization_information hoi2
2098: WHERE o1.business_group_id = g_business_group_id
2099: AND hoi1.organization_id = o1.organization_id
2100: AND hoi1.organization_id = csr_v_local_unit_id

Line 2097: ,hr_organization_information hoi2

2093: SELECT o1.NAME
2094: ,hoi2.org_information2
2095: FROM hr_organization_units o1
2096: ,hr_organization_information hoi1
2097: ,hr_organization_information hoi2
2098: WHERE o1.business_group_id = g_business_group_id
2099: AND hoi1.organization_id = o1.organization_id
2100: AND hoi1.organization_id = csr_v_local_unit_id
2101: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2160: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

2156:
2157: lr_get_prim_assignments csr_get_prim_assignments%ROWTYPE;
2158:
2159: CURSOR csr_chk_valid_le_lu (
2160: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
2161: ,csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
2162: )
2163: IS
2164: SELECT 'Y' "VALID"

Line 2161: ,csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

2157: lr_get_prim_assignments csr_get_prim_assignments%ROWTYPE;
2158:
2159: CURSOR csr_chk_valid_le_lu (
2160: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
2161: ,csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
2162: )
2163: IS
2164: SELECT 'Y' "VALID"
2165: FROM hr_organization_units o1

Line 2166: ,hr_organization_information hoi1

2162: )
2163: IS
2164: SELECT 'Y' "VALID"
2165: FROM hr_organization_units o1
2166: ,hr_organization_information hoi1
2167: ,hr_organization_information hoi2
2168: ,hr_organization_information hoi3
2169: WHERE o1.business_group_id = g_business_group_id
2170: AND hoi1.organization_id = o1.organization_id

Line 2167: ,hr_organization_information hoi2

2163: IS
2164: SELECT 'Y' "VALID"
2165: FROM hr_organization_units o1
2166: ,hr_organization_information hoi1
2167: ,hr_organization_information hoi2
2168: ,hr_organization_information hoi3
2169: WHERE o1.business_group_id = g_business_group_id
2170: AND hoi1.organization_id = o1.organization_id
2171: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2168: ,hr_organization_information hoi3

2164: SELECT 'Y' "VALID"
2165: FROM hr_organization_units o1
2166: ,hr_organization_information hoi1
2167: ,hr_organization_information hoi2
2168: ,hr_organization_information hoi3
2169: WHERE o1.business_group_id = g_business_group_id
2170: AND hoi1.organization_id = o1.organization_id
2171: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
2172: AND hoi1.org_information_context = 'CLASS'