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 212: select hr.name into l_org_name from hr_operating_units hr

208: l_run_autoinvoice_import := 'No';
209: END IF;
210:
211: IF (p_org_id is not null) THEN
212: select hr.name into l_org_name from hr_operating_units hr
213: where hr.organization_id = p_org_id;
214: END IF;
215:
216: IF (p_le_id is not null) THEN