eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PREPAY_PKG dependencies on AP_INVOICES

Line 36: FROM ap_invoices ai

32: cv_vendor_id NUMBER)
33: IS
34: SELECT DECODE(COUNT(*),
35: 0, 'INCONSISTENT PREPAY SUPPL', NULL)
36: FROM ap_invoices ai
37: WHERE ai.invoice_num = cv_prepay_num
38: AND ai.vendor_id = cv_vendor_id;
39:
40: BEGIN

Line 81: FROM ap_invoices ai

77: cv_invoice_currency_code VARCHAR2,
78: cv_payment_currency_code VARCHAR2) IS
79: SELECT DECODE(COUNT(*),
80: 0, 'INCONSISTENT PREPAY CURR', NULL)
81: FROM ap_invoices ai
82: WHERE invoice_num = cv_prepay_num
83: AND vendor_id = cv_vendor_id
84: AND cv_base_currency_code =
85: (SELECT base_currency_code

Line 141: FROM ap_invoices ai

137: END IF;
138:
139: SELECT count(*)
140: INTO l_count
141: FROM ap_invoices ai
142: WHERE ai.invoice_num = p_prepay_num
143: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
144: AND ai.payment_status_flag = 'Y'
145: AND ai.vendor_id = p_vendor_id

Line 160: FROM ap_invoices

156:
157: IF l_reject_code IS NULL THEN
158: SELECT invoice_id
159: INTO p_prepay_invoice_id
160: FROM ap_invoices
161: WHERE invoice_num = p_prepay_num
162: AND vendor_id = p_vendor_id;
163: END IF;
164:

Line 192: FROM ap_invoices ai,

188: cv_vendor_id NUMBER)
189: IS
190: SELECT DECODE(COUNT(*),
191: 0, 'INVALID PREPAY LINE NUM', NULL)
192: FROM ap_invoices ai,
193: ap_invoice_lines ail
194: WHERE ai.invoice_num = cv_prepay_num
195: AND ail.line_number = cv_prepay_line_num
196: AND ail.invoice_id = ai.invoice_id

Line 337: FROM ap_invoices ai,

333: CURSOR C_Check_No_Apply_Vendor_Amount
334: (cv_vendor_id NUMBER)
335: IS
336: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
337: FROM ap_invoices ai,
338: ap_invoice_lines ail,
339: ap_invoice_distributions aid
340: WHERE ai.vendor_id = cv_vendor_id
341: AND ai.invoice_type_lookup_code = 'PREPAYMENT'

Line 894: FROM ap_invoices ai,

890: 'VND_PREPAY_APPL_WITHOUT_AMOUNT_EXP') THEN
891: -- Get the Prepay Amount Remaining
892: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
893: INTO l_prepay_amount_remaining
894: FROM ap_invoices ai,
895: ap_invoice_lines ail,
896: ap_invoice_distributions aid
897: WHERE ai.vendor_id = p_vendor_id
898: AND ai.invoice_type_lookup_code = 'PREPAYMENT'

Line 966: FROM ap_invoices_all ai,

962: ail.line_number,
963: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
964: (ail.invoice_id,
965: ail.line_number)
966: FROM ap_invoices_all ai,
967: ap_invoice_lines_all ail
968: WHERE ai.invoice_id = cv_prepay_invoice_id
969: AND ail.invoice_id = ai.invoice_id
970: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

Line 987: FROM ap_invoices ai,

983: ail.line_number,
984: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
985: (ail.invoice_id,
986: ail.line_number)
987: FROM ap_invoices ai,
988: ap_invoice_lines ail
989: WHERE ai.vendor_id = cv_vendor_id
990: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
991: AND ai.payment_status_flag = 'Y'

Line 1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;

1410:
1411: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1412:
1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

Line 1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

1411: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1412:
1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

Line 1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;

1412:
1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

Line 1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;

1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

Line 1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:

Line 1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables

Line 1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

Line 1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;

Line 1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

Line 1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;

1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

Line 1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;

1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

Line 1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1431:

Line 1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1431:
1432: -- Prepayment Line Related Variables

Line 1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1431:
1432: -- Prepayment Line Related Variables
1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;

Line 1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1431:
1432: -- Prepayment Line Related Variables
1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

Line 1448: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;

1444:
1445: -- Prepayment Payment Related Variables
1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1447: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1448: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1450:
1451: -- Other Prepayment Application Related Variables
1452: l_apply_amount NUMBER := p_apply_amount;

Line 1509: FROM AP_Invoices

1505: exchange_rate_type,
1506: payment_currency_code,
1507: payment_cross_rate_date,
1508: payment_cross_rate_type
1509: FROM AP_Invoices
1510: WHERE invoice_id = CV_Std_Invoice_ID;
1511:
1512: CURSOR C_PPAY_INVOICE_INFO (CV_PPay_Invoice_ID IN NUMBER) IS
1513: SELECT invoice_currency_code,

Line 1520: FROM AP_Invoices

1516: exchange_rate_type,
1517: payment_currency_code,
1518: payment_cross_rate_date,
1519: payment_cross_rate_type
1520: FROM AP_Invoices
1521: WHERE invoice_id = CV_PPay_Invoice_ID;
1522:
1523: CURSOR C_PPAY_LINE_INFO (CV_PPAY_Invoice_ID IN NUMBER,
1524: CV_PPAY_LINE_NUM IN NUMBER) IS

Line 4443: l_debug_info := 'Update ap_invoices to reflect the amount applied p_apply_amount, p_invoice_id '||p_apply_amount||','||p_invoice_id;

4439: -- After update the payment schedules, the payment status flag should
4440: -- be updated according to the payment_status_flag of ap_payment_schedules
4441: -- to reflect the prepayment application
4442: --------------------------------------------------------------------------
4443: l_debug_info := 'Update ap_invoices to reflect the amount applied p_apply_amount, p_invoice_id '||p_apply_amount||','||p_invoice_id;
4444: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4445: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
4446: END IF;
4447:

Line 4450: UPDATE ap_invoices

4446: END IF;
4447:
4448: IF nvl(p_calling_mode,'X') <> 'RECOUPMENT' THEN
4449:
4450: UPDATE ap_invoices
4451: SET amount_paid = nvl(amount_paid,0) + p_apply_amount ,
4452: payment_status_flag =
4453: AP_INVOICES_UTILITY_PKG.get_payment_status(p_invoice_id ),
4454: last_update_date = SYSDATE,

Line 4453: AP_INVOICES_UTILITY_PKG.get_payment_status(p_invoice_id ),

4449:
4450: UPDATE ap_invoices
4451: SET amount_paid = nvl(amount_paid,0) + p_apply_amount ,
4452: payment_status_flag =
4453: AP_INVOICES_UTILITY_PKG.get_payment_status(p_invoice_id ),
4454: last_update_date = SYSDATE,
4455: last_updated_by = P_user_id,
4456: last_update_login = p_last_update_login
4457: WHERE invoice_id = p_invoice_id;

Line 4461: from ap_invoices

4457: WHERE invoice_id = p_invoice_id;
4458:
4459: SELECT amount_paid
4460: into l_amount_paid
4461: from ap_invoices
4462: where invoice_id=p_invoice_id;
4463:
4464: END IF;
4465:

Line 4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

4538: IS
4539:
4540: -- Prepayment Invoice Related Variables
4541:
4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
4543: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4546: l_ppay_apply_amt_in_pay_curr NUMBER;

Line 4543: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

4539:
4540: -- Prepayment Invoice Related Variables
4541:
4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
4543: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4546: l_ppay_apply_amt_in_pay_curr NUMBER;
4547: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;

Line 4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

4540: -- Prepayment Invoice Related Variables
4541:
4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
4543: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4546: l_ppay_apply_amt_in_pay_curr NUMBER;
4547: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;
4548: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;

Line 4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

4541:
4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
4543: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4546: l_ppay_apply_amt_in_pay_curr NUMBER;
4547: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;
4548: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;
4549: l_debug_info VARCHAR2(100);

Line 4565: FROM AP_Invoices

4561: SELECT invoice_currency_code,
4562: payment_currency_code,
4563: payment_cross_rate_date,
4564: payment_cross_rate_type
4565: FROM AP_Invoices
4566: WHERE invoice_id = CV_PPay_Invoice_ID;
4567:
4568: CURSOR C_PPAY_LINE_REC (CV_INVOICE_ID IN NUMBER,
4569: CV_LINE_NUM IN NUMBER)

Line 4849: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;

4845: l_apply_amount_remaining NUMBER;
4846: l_cursor_amount_remaining NUMBER;
4847: l_prepay_gl_date DATE := p_prepay_gl_date;
4848: l_prepay_period_name VARCHAR2(15):= p_prepay_period_name;
4849: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
4850: l_result BOOLEAN;
4851: l_debug_info VARCHAR2(100);
4852: l_current_calling_sequence VARCHAR2(2000);
4853: l_calling_program VARCHAR2(1000);

Line 4861: FROM ap_invoices ai

4857: CURSOR c_get_prepay_id (
4858: cv_prepay_num VARCHAR2,
4859: cv_vendor_id NUMBER) IS
4860: SELECT ai.invoice_id
4861: FROM ap_invoices ai
4862: WHERE ai.vendor_id = cv_vendor_id
4863: AND ai.invoice_num = cv_prepay_num
4864: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
4865: AND ai.payment_status_flag = 'Y'

Line 4874: FROM ap_invoices ai,

4870: ail.line_number,
4871: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
4872: (ail.invoice_id,
4873: ail.line_number)
4874: FROM ap_invoices ai,
4875: ap_invoice_lines ail
4876: WHERE ai.invoice_id = cv_prepay_invoice_id
4877: AND ail.invoice_id = ai.invoice_id
4878: AND AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining