DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on HR_OPERATING_UNITS

Line 4177: FROM hr_operating_units

4173: when no_data_found then
4174: print_debug('No IC Relations exists between from OU and To OU', 'GET_TRANSFER_PRICE_FOR_ITEM');
4175: SELECT name
4176: INTO l_from_ou_name
4177: FROM hr_operating_units
4178: WHERE organization_id = p_from_org_id;
4179:
4180:
4181: SELECT name

Line 4183: FROM hr_operating_units

4179:
4180:
4181: SELECT name
4182: INTO l_to_ou_name
4183: FROM hr_operating_units
4184: WHERE organization_id = p_to_org_id;
4185:
4186: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4187: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);

Line 4676: FROM hr_operating_units

4672: WHEN no_data_found then
4673: print_debug('No IC Relations exists between from OU and To OU', 'GET_TRANSFER_PRICE');
4674: select name
4675: INTO l_from_ou_name
4676: FROM hr_operating_units
4677: where organization_id = p_from_org_id;
4678:
4679: SELECT NAME
4680: INTO l_to_ou_name

Line 4681: From HR_OPERATING_UNITS

4677: where organization_id = p_from_org_id;
4678:
4679: SELECT NAME
4680: INTO l_to_ou_name
4681: From HR_OPERATING_UNITS
4682: Where organization_id = p_to_org_id;
4683:
4684: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4685: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);

Line 4767: FROM hr_operating_units

4763: when no_data_found then
4764: print_debug('no price list found ', 'GET_TRANSFER_PRICE');
4765: SELECT name
4766: into l_from_ou_name
4767: FROM hr_operating_units
4768: WHERE organization_id = p_from_org_id;
4769:
4770: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');
4771: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);