APPS.GMF_AP_INVOICE_CHECKS_INFO dependencies on AP_CHECKS_ALL

Line 15: FROM AP_CHECKS_ALL ach

11: ach.status_lookup_code,
12: ach.stopped_at,
13: ach.released_at,
14: ach.void_date
15: FROM AP_CHECKS_ALL ach
16: WHERE ach.check_id = NVL(checkid,ach.check_id) AND
17: ach.creation_date BETWEEN
18: nvl(startdate,ach.creation_date) AND
19: nvl(enddate,ach.creation_date);

Line 28: AP_CHECKS_ALL ach

24: aip.bank_account_type,
25: ach.currency_code,
26: ach.status_lookup_code
27: FROM AP_INVOICE_PAYMENTS_ALL aip,
28: AP_CHECKS_ALL ach
29: WHERE aip.check_id = NVL(checkid,aip.check_id) AND
30: aip.creation_date BETWEEN
31: nvl(startdate,aip.creation_date) AND
32: nvl(enddate,aip.creation_date)