DBA Data[Home] [Help]

APPS.IGI_ITR_ACCT_GENERATOR_PKG dependencies on IGI_ITR_CHARGE_SERVICE

Line 336: FROM igi_itr_charge_service serv

332: -- using the charge center and the charge service type chosen by the user
333: -- retrieve the creation charge center's service type account
334: SELECT creation_ccid
335: INTO l_creation_ccid
336: FROM igi_itr_charge_service serv
337: WHERE serv.charge_center_id = l_charge_center_id
338: AND serv.charge_service_id = l_charge_service_id
339: AND sysdate BETWEEN nvl(serv.start_date,sysdate)
340: AND nvl(serv.end_date,sysdate);

Line 890: FROM igi_itr_charge_service serv

886:
887: -- Fetch receiving ccid for service type
888: SELECT receiving_ccid
889: INTO l_service_receiving_ccid
890: FROM igi_itr_charge_service serv
891: WHERE serv.charge_service_id = l_charge_service_id
892: AND serv.charge_center_id = l_charge_center_id
893: AND sysdate BETWEEN nvl(serv.start_date,sysdate)
894: AND nvl(serv.end_date,sysdate);