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 855: FROM hr_all_organization_units o

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

Line 1414: FROM hr_all_organization_units o

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

Line 1433: FROM hr_all_organization_units o

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

Line 1452: FROM hr_all_organization_units o

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

Line 1469: FROM hr_all_organization_units o

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

Line 2071: FROM hr_all_organization_units o1

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