DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on HR_ORGANIZATION_UNITS

Line 507: FROM hr_organization_units

503:
504: -- Added for Bug 5202329
505: CURSOR c_get_exp_organization_id(c_business_group_id NUMBER, c_exp_organization_name VARCHAR) IS
506: SELECT organization_id
507: FROM hr_organization_units
508: WHERE business_group_id = c_business_group_id
509: AND name = c_exp_organization_name;
510:
511:

Line 1872: FROM hr_organization_units

1868: -- Start 1: Changed for Bug 5202329
1869: ELSE
1870: SELECT business_group_id
1871: INTO l_business_group_id
1872: FROM hr_organization_units
1873: WHERE organization_id = l_req_rec.expenditure_org_id;
1874: END IF;
1875: -- End 1: Changed for Bug 5202329
1876: END IF;