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 1871: FROM hr_organization_units

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