[Home] [Help]
706: ac.vendor_id
707: ,G_SRC_TYP_UNACCT_PMT_HISTORY
708: ,G_SRC_TAB_AP_PMT_HISTORY
709: FROM ap_payment_history_all aph,
710: ap_checks_all ac,
711: ap_org_attributes_gt orgs
712: WHERE aph.posted_flag IN ('N','S')
713: AND ac.check_id = aph.check_id
714: -- bug 7311486 UTR report must run even if dates and period is not specified
778: ac.vendor_id
779: ,G_SRC_TYP_UNACCT_INV_PMTS
780: ,G_SRC_TAB_AP_INV_PAYMENTS
781: FROM ap_invoice_payments_all aip,
782: ap_checks_All ac,
783: ap_org_attributes_gt orgs
784: WHERE aip.posted_flag IN ('N','S')
785: -- bug 7311486 UTR report must run even if dates and period is not specified
786: and (
1005: -- check if any unmatured future payments exists
1006: cursor c_unmat_fut_pmts_exists
1007: is
1008: select 'Y'
1009: from ap_checks_all c
1010: where c.future_pay_due_date is not null
1011: and c.status_lookup_code = 'ISSUED'
1012: and c.future_pay_due_date between g_period_start_date
1013: and g_period_end_date
1358: /* Modified the procedure for bug 7137359, related to AWT event creation */
1359: l_invoice_num VARCHAR2(50);
1360: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
1361: l_count NUMBER(15);
1362: l_check_id AP_CHECKS_ALL.Check_Id%TYPE;
1363: l_check_number AP_CHECKS_ALL.Check_Number%TYPE;
1364:
1365: BEGIN
1366:
1359: l_invoice_num VARCHAR2(50);
1360: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
1361: l_count NUMBER(15);
1362: l_check_id AP_CHECKS_ALL.Check_Id%TYPE;
1363: l_check_number AP_CHECKS_ALL.Check_Number%TYPE;
1364:
1365: BEGIN
1366:
1367: l_event_source_info.application_id := G_AP_APPLICATION_ID;
1380: BEGIN
1381: select ac.check_id, ac.check_number
1382: into l_check_id, l_check_number
1383: from ap_invoice_payments_all aip,
1384: ap_checks_all ac
1385: where aip.check_id=ac.check_id
1386: and aip.accounting_event_id = p_event_id
1387: and aip.invoice_id= p_trans_id;
1388: