APPS.INV_TRANSACTION_FLOW_PUB dependencies on HR_OPERATING_UNITS

Line 4095: FROM hr_operating_units

4091: when no_data_found then
4092: print_debug('No IC Relations exists between from OU and To OU', 'GET_TRANSFER_PRICE_FOR_ITEM');
4093: SELECT name
4094: INTO l_from_ou_name
4095: FROM hr_operating_units
4096: WHERE organization_id = p_from_org_id;
4097:
4098:
4099: SELECT name

Line 4101: FROM hr_operating_units

4097:
4098:
4099: SELECT name
4100: INTO l_to_ou_name
4101: FROM hr_operating_units
4102: WHERE organization_id = p_to_org_id;
4103:
4104: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4105: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);

Line 4507: FROM hr_operating_units

4503: WHEN no_data_found then
4504: print_debug('No IC Relations exists between from OU and To OU', 'GET_TRANSFER_PRICE');
4505: select name
4506: INTO l_from_ou_name
4507: FROM hr_operating_units
4508: where organization_id = p_from_org_id;
4509:
4510: SELECT NAME
4511: INTO l_to_ou_name

Line 4512: From HR_OPERATING_UNITS

4508: where organization_id = p_from_org_id;
4509:
4510: SELECT NAME
4511: INTO l_to_ou_name
4512: From HR_OPERATING_UNITS
4513: Where organization_id = p_to_org_id;
4514:
4515: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4516: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);

Line 4598: FROM hr_operating_units

4594: when no_data_found then
4595: print_debug('no price list found ', 'GET_TRANSFER_PRICE');
4596: SELECT name
4597: into l_from_ou_name
4598: FROM hr_operating_units
4599: WHERE organization_id = p_from_org_id;
4600:
4601: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');
4602: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);