APPS.AR_IREC_APPLY_CREDITS dependencies on AR_IREC_PAYMENT_LIST_GT

Line 143: FROM ar_irec_payment_list_gt

139: LAST_UPDATE_LOGIN,
140: CASH_RECEIPT_ID,
141: PAY_FOR_CUSTOMER_ID,
142: PAY_FOR_CUSTOMER_SITE_ID
143: FROM ar_irec_payment_list_gt
144: WHERE CUSTOMER_ID = p_customer_id
145: AND CUSTOMER_SITE_USE_ID = nvl(p_customer_site_use_id,CUSTOMER_SITE_USE_ID)
146: AND CURRENCY_CODE = p_currency_code;
147:

Line 2006: DELETE FROM AR_IREC_PAYMENT_LIST_GT

2002: IF (PG_DEBUG = 'Y') THEN
2003: arp_standard.debug(l_debug_info);
2004: END IF;
2005:
2006: DELETE FROM AR_IREC_PAYMENT_LIST_GT
2007: WHERE CUSTOMER_ID = p_customer_id
2008: AND CUSTOMER_SITE_USE_ID = nvl(p_customer_site_use_id,CUSTOMER_SITE_USE_ID)
2009: AND CURRENCY_CODE = p_currency_code;
2010: