APPS.PA_ADJUSTMENTS dependencies on AP_INVOICE_PAYMENTS_ALL

Line 5731: ' from ap_invoice_payments_all' ||

5727: IF p_check_id IS NOT NULL THEN
5728: where_clause := where_clause ||
5729: ' and ei.document_payment_id in' ||
5730: ' (select invoice_payment_id' ||
5731: ' from ap_invoice_payments_all' ||
5732: ' where check_id = :check_id) ';
5733: END IF;
5734:
5735: IF p_rev_exp_items_req_adjust = 'Y' THEN

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

9885: p_expenditure_organization_id IN NUMBER,
9886: p_expenditure_item_date IN DATE,
9887: p_emp_id IN NUMBER,
9888: p_invoice_distribution_id IN NUMBER,
9889: p_invoice_payment_id IN AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE, /* Bug 5006835 */
9890: p_award_id IN NUMBER,
9891: p_billable_flag1 IN VARCHAR2,
9892: p_billable_flag2 IN VARCHAR2,
9893: x_encoded_error_message OUT NOCOPY VARCHAR2) /* Bug 4997739 */

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

9906:
9907: /* Bug 5006835 - Start */
9908: /* This cursor is used to determine if the disbursement bank account is pooled
9909: for a payment in cash basis accounting setup */
9910: CURSOR c_get_pooled_flag(p_invoice_payment_id AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE) IS
9911: SELECT B.POOLED_FLAG
9912: FROM CE_BANK_ACCOUNTS B
9913: , AP_CHECKS_ALL C
9914: , AP_INVOICE_PAYMENTS_ALL A

Line 9914: , AP_INVOICE_PAYMENTS_ALL A

9910: CURSOR c_get_pooled_flag(p_invoice_payment_id AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE) IS
9911: SELECT B.POOLED_FLAG
9912: FROM CE_BANK_ACCOUNTS B
9913: , AP_CHECKS_ALL C
9914: , AP_INVOICE_PAYMENTS_ALL A
9915: WHERE A.INVOICE_PAYMENT_ID = p_invoice_payment_id
9916: AND A.CHECK_ID = C.CHECK_ID
9917: AND C.CE_BANK_ACCT_USE_ID = B.BANK_ACCOUNT_ID;
9918: /* Bug 5006835 - End */