APPS.IEX_PROMISES_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 869: 'FROM AR_PAYMENT_SCHEDULES PSA, IEX_DELINQUENCIES DEL ' ||

865: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
866: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.CURRENCY_CODE);
867: END IF;
868: l_SQL := 'SELECT PSA.INVOICE_CURRENCY_CODE ' ||
869: 'FROM AR_PAYMENT_SCHEDULES PSA, IEX_DELINQUENCIES DEL ' ||
870: 'WHERE ' ||
871: 'DEL.DELINQUENCY_ID = :P_DELINQUENCY_ID AND ' ||
872: 'DEL.PAYMENT_SCHEDULE_ID = PSA.PAYMENT_SCHEDULE_ID';
873:

Line 2564: ' FROM iex_delinquencies del, ar_payment_schedules psa ' ||

2560: -- l_SQL := 'SELECT CUSTOMER_ID, CUSTOMER_SITE_USE_ID, payment_schedule_id' ||
2561: -- ' from iex_pay_invoices_v where delinquency_id = :P_DEL_ID';
2562:
2563: l_SQL := 'SELECT psa.CUSTOMER_ID, psa.CUSTOMER_SITE_USE_ID, del.payment_schedule_id ' ||
2564: ' FROM iex_delinquencies del, ar_payment_schedules psa ' ||
2565: ' WHERE psa.payment_schedule_id = del.payment_schedule_id and psa.status = ''OP'' and ' ||
2566: ' psa.AMOUNT_DUE_REMAINING > 0 and del.DELINQUENCY_ID = :P_DEL_ID';
2567:
2568: open l_cursor for l_SQL

Line 2665: ' FROM iex_delinquencies del, ar_payment_schedules psa ' ||

2661: close l_cursor;
2662:
2663: -- fixed a perf bug 4930381 l_SQL := 'SELECT CUSTOMER_ID, AMOUNT_DUE_REMAINING, INVOICE_CURRENCY_CODE, CUSTOMER_SITE_USE_ID FROM iex_pay_invoices_v WHERE DELINQUENCY_ID = :P_DEL_ID';
2664: l_SQL := 'SELECT psa.CUSTOMER_ID, psa.AMOUNT_DUE_REMAINING, psa.INVOICE_CURRENCY_CODE, psa.CUSTOMER_SITE_USE_ID '||
2665: ' FROM iex_delinquencies del, ar_payment_schedules psa ' ||
2666: ' WHERE psa.payment_schedule_id = del.payment_schedule_id and psa.status = ''OP'' and ' ||
2667: ' psa.AMOUNT_DUE_REMAINING > 0 and del.DELINQUENCY_ID = :P_DEL_ID';
2668: open l_cursor for l_SQL
2669: using P_MASS_IDS_TBL(i);

Line 3029: from ar_payment_schedules pay,

3025: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'l_total_already_pro_amt: ' || l_total_already_pro_amt);
3026: END IF;
3027: Begin
3028: SELECT amount_due_remaining into l_amt_due_remaining
3029: from ar_payment_schedules pay,
3030: iex_delinquencies del
3031: where
3032: del.payment_schedule_id = pay.payment_schedule_id
3033: and del.delinquency_id = l_promised_delinquency_id;