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_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 862: ,hr_organization_information hoi1

858: -- AND as1.effective_end_date
859: AND act.tax_unit_id IN (
860: SELECT o.organization_id
861: FROM hr_all_organization_units o
862: ,hr_organization_information hoi1
863: ,hr_organization_information hoi2
864: WHERE o.business_group_id = g_business_group_id
865: AND hoi1.organization_id = o.organization_id
866: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 863: ,hr_organization_information hoi2

859: AND act.tax_unit_id IN (
860: SELECT o.organization_id
861: FROM hr_all_organization_units o
862: ,hr_organization_information hoi1
863: ,hr_organization_information hoi2
864: WHERE o.business_group_id = g_business_group_id
865: AND hoi1.organization_id = o.organization_id
866: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
867: AND hoi1.org_information_context = 'CLASS'

Line 894: l_pension_type hr_organization_information.org_information1%TYPE;

890: l_count NUMBER := 0;
891: l_prev_prepay NUMBER := 0;
892: l_canonical_start_date DATE;
893: l_canonical_end_date DATE;
894: l_pension_type hr_organization_information.org_information1%TYPE;
895: l_prepay_action_id NUMBER;
896: l_actid NUMBER;
897: l_assignment_id NUMBER;
898: l_action_sequence NUMBER;

Line 1421: ,hr_organization_information hoi1

1417: CURSOR csr_get_all_legal_employer_id
1418: IS
1419: SELECT o.organization_id
1420: FROM hr_all_organization_units o
1421: ,hr_organization_information hoi1
1422: ,hr_organization_information hoi2
1423: WHERE o.business_group_id = g_business_group_id
1424: AND hoi1.organization_id = o.organization_id
1425: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1422: ,hr_organization_information hoi2

1418: IS
1419: SELECT o.organization_id
1420: FROM hr_all_organization_units o
1421: ,hr_organization_information hoi1
1422: ,hr_organization_information hoi2
1423: WHERE o.business_group_id = g_business_group_id
1424: AND hoi1.organization_id = o.organization_id
1425: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1426: AND hoi1.org_information_context = 'CLASS'

Line 1440: , hr_organization_information hoi1

1436: /* CURSOR csr_get_all_Legal_employer_id
1437: IS
1438: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1439: FROM hr_all_organization_units o
1440: , hr_organization_information hoi1
1441: , hr_organization_information hoi2
1442: , hr_organization_information hoi3
1443: WHERE o.business_group_id = g_business_group_id
1444: AND hoi1.organization_id = o.organization_id

Line 1441: , hr_organization_information hoi2

1437: IS
1438: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1439: FROM hr_all_organization_units o
1440: , hr_organization_information hoi1
1441: , hr_organization_information hoi2
1442: , hr_organization_information hoi3
1443: WHERE o.business_group_id = g_business_group_id
1444: AND hoi1.organization_id = o.organization_id
1445: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1442: , hr_organization_information hoi3

1438: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1439: FROM hr_all_organization_units o
1440: , hr_organization_information hoi1
1441: , hr_organization_information hoi2
1442: , hr_organization_information hoi3
1443: WHERE o.business_group_id = g_business_group_id
1444: AND hoi1.organization_id = o.organization_id
1445: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1446: AND hoi1.org_information_context = 'CLASS'

Line 1459: , hr_organization_information hoi1

1455: CURSOR csr_get_all_info(csr_v_LE_id NUMBER)
1456: IS
1457: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1458: FROM hr_all_organization_units o
1459: , hr_organization_information hoi1
1460: , hr_organization_information hoi3
1461: WHERE o.business_group_id = g_business_group_id
1462: AND hoi1.organization_id = o.organization_id
1463: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1460: , hr_organization_information hoi3

1456: IS
1457: select o.organization_id,hoi3.ORG_INFORMATION1,hoi3.ORG_INFORMATION2
1458: FROM hr_all_organization_units o
1459: , hr_organization_information hoi1
1460: , hr_organization_information hoi3
1461: WHERE o.business_group_id = g_business_group_id
1462: AND hoi1.organization_id = o.organization_id
1463: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1464: AND hoi1.org_information_context = 'CLASS'

Line 1476: ,hr_organization_information hoi1

1472: SELECT o.organization_id
1473: ,hoi3.org_information1
1474: ,hoi3.org_information2
1475: FROM hr_all_organization_units o
1476: ,hr_organization_information hoi1
1477: ,hr_organization_information hoi3
1478: WHERE o.business_group_id = g_business_group_id
1479: AND hoi1.organization_id = o.organization_id
1480: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1477: ,hr_organization_information hoi3

1473: ,hoi3.org_information1
1474: ,hoi3.org_information2
1475: FROM hr_all_organization_units o
1476: ,hr_organization_information hoi1
1477: ,hr_organization_information hoi3
1478: WHERE o.business_group_id = g_business_group_id
1479: AND hoi1.organization_id = o.organization_id
1480: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1481: AND hoi1.org_information_context = 'CLASS'

Line 2037: ,hr_organization_information hoi1

2033: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2034: AND scl.segment2 IN (
2035: SELECT o1.organization_id
2036: FROM hr_organization_units o1
2037: ,hr_organization_information hoi1
2038: ,hr_organization_information hoi2
2039: ,hr_organization_information hoi3
2040: WHERE o1.business_group_id = g_business_group_id
2041: AND hoi1.organization_id = o1.organization_id

Line 2038: ,hr_organization_information hoi2

2034: AND scl.segment2 IN (
2035: SELECT o1.organization_id
2036: FROM hr_organization_units o1
2037: ,hr_organization_information hoi1
2038: ,hr_organization_information hoi2
2039: ,hr_organization_information hoi3
2040: WHERE o1.business_group_id = g_business_group_id
2041: AND hoi1.organization_id = o1.organization_id
2042: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2039: ,hr_organization_information hoi3

2035: SELECT o1.organization_id
2036: FROM hr_organization_units o1
2037: ,hr_organization_information hoi1
2038: ,hr_organization_information hoi2
2039: ,hr_organization_information hoi3
2040: WHERE o1.business_group_id = g_business_group_id
2041: AND hoi1.organization_id = o1.organization_id
2042: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
2043: AND hoi1.org_information_context = 'CLASS'

Line 2082: csr_v_organization_id hr_organization_information.organization_id%TYPE

2078: lr_get_segment2 csr_get_segment2%ROWTYPE;
2079:
2080: -- Cursor to pick up LEGAL EMPLOYER
2081: CURSOR csr_find_legal_employer (
2082: csr_v_organization_id hr_organization_information.organization_id%TYPE
2083: )
2084: IS
2085: SELECT hoi3.organization_id legal_id
2086: FROM hr_all_organization_units o1

Line 2087: ,hr_organization_information hoi1

2083: )
2084: IS
2085: SELECT hoi3.organization_id legal_id
2086: FROM hr_all_organization_units o1
2087: ,hr_organization_information hoi1
2088: ,hr_organization_information hoi2
2089: ,hr_organization_information hoi3
2090: WHERE o1.business_group_id = g_business_group_id
2091: AND hoi1.organization_id = o1.organization_id

Line 2088: ,hr_organization_information hoi2

2084: IS
2085: SELECT hoi3.organization_id legal_id
2086: FROM hr_all_organization_units o1
2087: ,hr_organization_information hoi1
2088: ,hr_organization_information hoi2
2089: ,hr_organization_information hoi3
2090: WHERE o1.business_group_id = g_business_group_id
2091: AND hoi1.organization_id = o1.organization_id
2092: AND hoi1.organization_id = csr_v_organization_id

Line 2089: ,hr_organization_information hoi3

2085: SELECT hoi3.organization_id legal_id
2086: FROM hr_all_organization_units o1
2087: ,hr_organization_information hoi1
2088: ,hr_organization_information hoi2
2089: ,hr_organization_information hoi3
2090: WHERE o1.business_group_id = g_business_group_id
2091: AND hoi1.organization_id = o1.organization_id
2092: AND hoi1.organization_id = csr_v_organization_id
2093: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2105: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

2101: lr_find_legal_employer csr_find_legal_employer%ROWTYPE;
2102:
2103: -- Cursor to pick up Local Unit Details
2104: CURSOR csr_local_unit_details (
2105: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
2106: )
2107: IS
2108: SELECT o1.NAME
2109: ,hoi2.org_information2

Line 2111: ,hr_organization_information hoi1

2107: IS
2108: SELECT o1.NAME
2109: ,hoi2.org_information2
2110: FROM hr_organization_units o1
2111: ,hr_organization_information hoi1
2112: ,hr_organization_information hoi2
2113: WHERE o1.business_group_id = g_business_group_id
2114: AND hoi1.organization_id = o1.organization_id
2115: AND hoi1.organization_id = csr_v_local_unit_id

Line 2112: ,hr_organization_information hoi2

2108: SELECT o1.NAME
2109: ,hoi2.org_information2
2110: FROM hr_organization_units o1
2111: ,hr_organization_information hoi1
2112: ,hr_organization_information hoi2
2113: WHERE o1.business_group_id = g_business_group_id
2114: AND hoi1.organization_id = o1.organization_id
2115: AND hoi1.organization_id = csr_v_local_unit_id
2116: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2175: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

2171:
2172: lr_get_prim_assignments csr_get_prim_assignments%ROWTYPE;
2173:
2174: CURSOR csr_chk_valid_le_lu (
2175: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
2176: ,csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
2177: )
2178: IS
2179: SELECT 'Y' "VALID"

Line 2176: ,csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

2172: lr_get_prim_assignments csr_get_prim_assignments%ROWTYPE;
2173:
2174: CURSOR csr_chk_valid_le_lu (
2175: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
2176: ,csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
2177: )
2178: IS
2179: SELECT 'Y' "VALID"
2180: FROM hr_organization_units o1

Line 2181: ,hr_organization_information hoi1

2177: )
2178: IS
2179: SELECT 'Y' "VALID"
2180: FROM hr_organization_units o1
2181: ,hr_organization_information hoi1
2182: ,hr_organization_information hoi2
2183: ,hr_organization_information hoi3
2184: WHERE o1.business_group_id = g_business_group_id
2185: AND hoi1.organization_id = o1.organization_id

Line 2182: ,hr_organization_information hoi2

2178: IS
2179: SELECT 'Y' "VALID"
2180: FROM hr_organization_units o1
2181: ,hr_organization_information hoi1
2182: ,hr_organization_information hoi2
2183: ,hr_organization_information hoi3
2184: WHERE o1.business_group_id = g_business_group_id
2185: AND hoi1.organization_id = o1.organization_id
2186: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 2183: ,hr_organization_information hoi3

2179: SELECT 'Y' "VALID"
2180: FROM hr_organization_units o1
2181: ,hr_organization_information hoi1
2182: ,hr_organization_information hoi2
2183: ,hr_organization_information hoi3
2184: WHERE o1.business_group_id = g_business_group_id
2185: AND hoi1.organization_id = o1.organization_id
2186: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
2187: AND hoi1.org_information_context = 'CLASS'