APPS.PQP_PENSION_PROVIDERS dependencies on HR_ORGANIZATION_UNITS_V

Line 367: from hr_organization_units_v

363: ,p_date_to in date ) Is
364:
365: Cursor csr_org Is
366: Select *
367: from hr_organization_units_v
368: where organization_id = p_organization_id;
369:
370: l_proc varchar2(150) := g_package||'update_pension_provider';
371: l_org_rec csr_org%ROWTYPE;

Line 1201: from hr_organization_units_v

1197:
1198:
1199: Cursor csr_org Is
1200: Select *
1201: from hr_organization_units_v
1202: where organization_id = p_organization_id;
1203:
1204: Cursor csr_org_info Is
1205: Select rowid,org_information_id,org_information_context,org_information1

Line 1447: from hr_organization_units_v

1443:
1444:
1445: Cursor csr_org Is
1446: Select *
1447: from hr_organization_units_v
1448: where organization_id = p_organization_id;
1449:
1450: Cursor csr_org_info Is
1451: Select rowid,org_information_id,org_information_context,org_information1

Line 1692: from hr_organization_units_v

1688:
1689:
1690: Cursor csr_org Is
1691: Select *
1692: from hr_organization_units_v
1693: where organization_id = p_organization_id;
1694:
1695: Cursor csr_org_info Is
1696: Select rowid,org_information_id,org_information_context,org_information1