APPS.PAY_SE_INCOME_STATEMENT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 302: csr_v_media_provider_id hr_all_organization_units.organization_id%TYPE

298: l_medium_identity varchar2(30);
299: l_medium_program varchar2(30);
300:
301: CURSOR csr_media_provider_details (
302: csr_v_media_provider_id hr_all_organization_units.organization_id%TYPE
303: )
304: IS
305: SELECT o.NAME "MP_NAME",o.location_id
306: ,hoi1.org_information1 "MP_ORG_NUMBER"

Line 310: FROM hr_all_organization_units o

306: ,hoi1.org_information1 "MP_ORG_NUMBER"
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

Line 861: FROM hr_all_organization_units o

857: -- AND ppa.effective_date BETWEEN as1.effective_start_date
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

Line 1420: FROM hr_all_organization_units o

1416:
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

Line 1439: FROM hr_all_organization_units o

1435:
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

Line 1458: FROM hr_all_organization_units o

1454: /*
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

Line 1475: FROM hr_all_organization_units o

1471: IS
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

Line 2086: FROM hr_all_organization_units o1

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
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