DBA Data[Home] [Help]

APPS.IGI_CIS_CI36_DATA_PKG dependencies on IGI_CIS_GET_PROFILE

Line 239: AND aag.name = igi_cis_get_profile.cis_tax_group

235: ap_checks ac
236: WHERE ai.payment_status_flag = 'Y'
237: AND ai.invoice_id = icip.invoice_id
238: AND ai.awt_group_id = aag.group_id
239: AND aag.name = igi_cis_get_profile.cis_tax_group
240: AND icip.check_id = ac.check_id
241: AND ac.void_date IS NULL
242: AND ai.vendor_id = nvl(x_vendor_id,ai.vendor_id)
243: AND TRUNC(NVL(ac.check_date,x_low_date)) BETWEEN TRUNC(x_low_date) AND TRUNC(x_high_date);