APPS.IGI_CIS2007_IGIPSUPR_PKG dependencies on IGI_CIS_MTH_RET_LINES_H

Line 301: from igi_cis_mth_ret_hdr_h hdr, igi_cis_mth_ret_lines_h line

297: AS
298: v_tmp number(1);
299: Begin
300: select 1 into v_tmp
301: from igi_cis_mth_ret_hdr_h hdr, igi_cis_mth_ret_lines_h line
302: where hdr.header_id = line.header_id
303: and line.vendor_id = p_vendor_id
304: and hdr.period_ending_date between p_start_date and p_end_date
305: and rownum = 1;