APPS.PA_ADJUSTMENTS dependencies on AP_INVOICE_PAYMENTS_ALL

Line 5875: ' from ap_invoice_payments_all' ||

5871: IF p_check_id IS NOT NULL THEN
5872: where_clause := where_clause ||
5873: ' and ei.document_payment_id in' ||
5874: ' (select invoice_payment_id' ||
5875: ' from ap_invoice_payments_all' ||
5876: ' where check_id = :check_id) ';
5877: END IF;
5878:
5879: IF p_rev_exp_items_req_adjust = 'Y' THEN

Line 10172: p_invoice_payment_id IN AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE, /* Bug 5006835 */

10168: p_expenditure_organization_id IN NUMBER,
10169: p_expenditure_item_date IN DATE,
10170: p_emp_id IN NUMBER,
10171: p_invoice_distribution_id IN NUMBER,
10172: p_invoice_payment_id IN AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE, /* Bug 5006835 */
10173: p_award_id IN NUMBER,
10174: p_billable_flag1 IN VARCHAR2,
10175: p_billable_flag2 IN VARCHAR2,
10176: x_encoded_error_message OUT NOCOPY VARCHAR2) /* Bug 4997739 */

Line 10193: CURSOR c_get_pooled_flag(p_invoice_payment_id AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE) IS

10189:
10190: /* Bug 5006835 - Start */
10191: /* This cursor is used to determine if the disbursement bank account is pooled
10192: for a payment in cash basis accounting setup */
10193: CURSOR c_get_pooled_flag(p_invoice_payment_id AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE) IS
10194: SELECT B.POOLED_FLAG
10195: FROM CE_BANK_ACCOUNTS B
10196: , AP_CHECKS_ALL C
10197: , AP_INVOICE_PAYMENTS_ALL A

Line 10197: , AP_INVOICE_PAYMENTS_ALL A

10193: CURSOR c_get_pooled_flag(p_invoice_payment_id AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE) IS
10194: SELECT B.POOLED_FLAG
10195: FROM CE_BANK_ACCOUNTS B
10196: , AP_CHECKS_ALL C
10197: , AP_INVOICE_PAYMENTS_ALL A
10198: WHERE A.INVOICE_PAYMENT_ID = p_invoice_payment_id
10199: AND A.CHECK_ID = C.CHECK_ID
10200: AND C.CE_BANK_ACCT_USE_ID = B.BANK_ACCOUNT_ID;
10201: /* Bug 5006835 - End */