APPS.IGI_STP_NET_DOC_PKG dependencies on STANDARD

Line 128: and trx_type = 'STANDARD'

124: WHERE user_id = x_user_id
125: and stp_id = x_vendor_id
126: and currency_code = x_currency_code
127: and application = 'AP'
128: and trx_type = 'STANDARD'
129: and trx_number >= nvl(x_ap_trx_min, v_ap_trx_min)
130: and trx_number <= nvl(x_ap_trx_max, v_ap_trx_max)
131: and process_flag = 'R';
132:

Line 170: and trx_type in ('STANDARD', 'INV')

166: -- , package_num = x_counter
167: WHERE user_id = x_user_id
168: and currency_code = x_currency_code
169: and stp_id in ( x_customer_id, x_vendor_id)
170: and trx_type in ('STANDARD', 'INV')
171: and reference = rec_match.reference
172: and process_flag = 'R';
173: -- x_counter := x_counter + 1;
174: end loop;

Line 192: and trx_type = decode(x_type, 6,'CREDIT', 'STANDARD')

188: WHERE user_id = x_user_id
189: and stp_id = x_vendor_id
190: and currency_code = x_currency_code
191: and application = 'AP'
192: and trx_type = decode(x_type, 6,'CREDIT', 'STANDARD')
193: and trx_number >= nvl(x_ap_trx_min, v_ap_trx_min)
194: and trx_number <= nvl(x_ap_trx_max, v_ap_trx_max)
195: and process_flag = 'R';
196: END IF;