APPS.AP_PAY_INVOICE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 245: * -- Step 4 : case for all : Insert AP_INVOICE_PAYMENTS

241:
242: end if;
243:
244: /*--------------------------------------------------------------------------
245: * -- Step 4 : case for all : Insert AP_INVOICE_PAYMENTS
246: * Call ap_pay_insert_invoice_payments :
247: *
248: *--------------------------------------------------------------------------*/
249: ap_pay_invoice_pkg.ap_pay_insert_invoice_payments(

Line 552: FROM ap_invoice_payments

548: 0-NVL(invoice_base_amount,0)),
549: DECODE(payment_base_amount ,'','',
550: 0-NVL(payment_base_amount,0))
551: INTO P_invoice_base_amount, P_payment_base_amount
552: FROM ap_invoice_payments
553: WHERE invoice_payment_id = P_old_invoice_payment_id;
554:
555: end if;
556:

Line 715: FROM ap_invoice_payments AIP

711: SUM(NVL(AIP.discount_taken,0))
712: , AP_INVOICES_UTILITY_PKG.get_payment_status( P_invoice_id )
713: , P_last_update_date
714: , P_last_updated_by
715: FROM ap_invoice_payments AIP
716: WHERE AIP.invoice_id = P_invoice_id
717: AND AIP.check_id = P_check_id
718: GROUP BY AI.invoice_id
719: , AI.amount_paid

Line 772: * This function: Update AP_INVOICE_PAYMENTS

768:
769: /*========================================================================
770: *** Pubilic Function ***
771: ************************
772: * This function: Update AP_INVOICE_PAYMENTS
773: * Inserts a new invoice payment line
774: *========================================================================*/
775: PROCEDURE ap_pay_insert_invoice_payments(
776: P_invoice_id IN NUMBER,

Line 863: debug_info := 'Insert ap_invoice_payments';

859: -- Update the calling sequence
860: --
861: current_calling_sequence := 'AP_PAY_INVOICE_PKG.ap_pay_insert_invoice_payments<-'||P_calling_sequence;
862:
863: debug_info := 'Insert ap_invoice_payments';
864: AP_AIP_TABLE_HANDLER_PKG.Insert_Row(
865: P_invoice_id,
866: P_check_id,
867: P_payment_num,

Line 1085: FROM ap_invoice_payments AIP

1081: -- SELECT statement added by Bug 8300099
1082: /* Bug 10640186 begin */
1083: SELECT DECODE( NVL( SUM(AIP.amount), 0 ), 0, 'N', 'Y' )
1084: INTO l_another_pmt
1085: FROM ap_invoice_payments AIP
1086: WHERE AIP.invoice_id = p_invoice_id
1087: AND AIP.payment_num = p_payment_num
1088: AND AIP.check_id <> p_check_id ;
1089:

Line 1131: FROM ap_invoice_payments AIP

1127: SELECT DECODE(APS.gross_amount, APS.amount_remaining
1128: + SUM(AIP.amount)
1129: + SUM(NVL(AIP.discount_taken,0)), 'N', 'P')
1130: INTO l_pmt_status_flag
1131: FROM ap_invoice_payments AIP
1132: , ap_payment_schedules APS
1133: WHERE AIP.invoice_id = P_invoice_id
1134: AND AIP.payment_num = P_payment_num
1135: AND AIP.check_id = P_check_id

Line 1167: FROM ap_invoice_payments AIP,ap_invoices AI --bug2182168 added ap_invoices AI

1163: + SUM(NVL(AIP.discount_taken,0)), 'N', 'P')/*DECODE(AI.amount_paid,SUM(AIP.amount),'N','P')*/
1164: -- 2182168 modified the decode statement to compare amount_paid to amount cancelled
1165: , P_last_update_date
1166: , P_last_updated_by
1167: FROM ap_invoice_payments AIP,ap_invoices AI --bug2182168 added ap_invoices AI
1168: WHERE AIP.invoice_id = P_invoice_id
1169: AND AIP.payment_num = P_payment_num
1170: AND AIP.check_id = P_check_id
1171: AND AI.invoice_id=P_invoice_id --bug2182168 added condition

Line 1209: FROM ap_invoice_payments AIP

1205: , 'N' */
1206: , l_pmt_status_flag
1207: , P_last_update_date
1208: , P_last_updated_by
1209: FROM ap_invoice_payments AIP
1210: WHERE AIP.invoice_id = P_invoice_id
1211: AND AIP.check_id = P_check_id
1212: AND AIP.payment_num = APS.payment_num -- Bug 7184181
1213: GROUP BY AIP.invoice_id)

Line 1272: FROM ap_invoice_payments aip

1268: BEGIN
1269:
1270: SELECT sum(amount)
1271: INTO check_amount
1272: FROM ap_invoice_payments aip
1273: WHERE aip.check_id = x_check_id;
1274:
1275: RETURN(check_amount);
1276:

Line 1317: FROM ap_invoice_payments

1313: -- Get amount_from org_invoice_pay_id
1314: --
1315: SELECT amount, discount_taken
1316: INTO p_amount, p_discount
1317: FROM ap_invoice_payments
1318: WHERE invoice_payment_id = p_org_invoice_pay_id;
1319:
1320:
1321: -- Bug 1544895 - The update statement for AP_INVOICES that appears below the update