DBA Data[Home] [Help]

APPS.FUN_AR_BATCH_TRANSFER dependencies on HR_OPERATING_UNITS

Line 177: FROM hr_operating_units ou

173:
174: CURSOR ou_valid_csr (p_ou_id NUMBER,
175: p_trx_date DATE) IS
176: SELECT count(*)
177: FROM hr_operating_units ou
178: WHERE organization_id = p_ou_id
179: AND date_from <= p_trx_date
180: AND NVL(date_to, p_trx_date) >= p_trx_date;
181:

Line 198: select hr.name into l_org_name from hr_operating_units hr

194: l_run_autoinvoice_import := 'No';
195: END IF;
196:
197: IF (p_org_id is not null) THEN
198: select hr.name into l_org_name from hr_operating_units hr
199: where hr.organization_id = p_org_id;
200: END IF;
201:
202: IF (p_le_id is not null) THEN