DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on HR_OPERATING_UNITS

Line 2211: FROM hr_operating_units ou

2207: recipient_name HZ_PARTIES.PARTY_NAME%TYPE;
2208:
2209: CURSOR ou_valid_csr IS
2210: SELECT count(*)
2211: FROM hr_operating_units ou
2212: WHERE organization_id = l_from_ou_id
2213: AND date_from <= p_trx_date
2214: AND NVL(date_to, p_trx_date) >= p_trx_date; --
2215: BEGIN

Line 4522: FROM hr_operating_units ou

4518: l_msg_data VARCHAR2(2000);
4519: l_count NUMBER;
4520: CURSOR ou_valid_csr IS
4521: SELECT count(*)
4522: FROM hr_operating_units ou
4523: WHERE organization_id = l_to_ou_id
4524: AND date_from <= p_trx_date
4525: AND NVL(date_to, p_trx_date) >= p_trx_date; --
4526: