DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on HR_OPERATING_UNITS

Line 2099: FROM hr_operating_units ou

2095: recipient_name HZ_PARTIES.PARTY_NAME%TYPE;
2096:
2097: CURSOR ou_valid_csr IS
2098: SELECT count(*)
2099: FROM hr_operating_units ou
2100: WHERE organization_id = l_from_ou_id
2101: AND date_from <= p_trx_date
2102: AND NVL(date_to, p_trx_date) >= p_trx_date; --
2103: BEGIN

Line 4226: FROM hr_operating_units ou

4222: l_msg_data VARCHAR2(2000);
4223: l_count NUMBER;
4224: CURSOR ou_valid_csr IS
4225: SELECT count(*)
4226: FROM hr_operating_units ou
4227: WHERE organization_id = l_to_ou_id
4228: AND date_from <= p_trx_date
4229: AND NVL(date_to, p_trx_date) >= p_trx_date; --
4230: