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.IBY_VALIDATIONSETS_PUB dependencies on IBY_PAYMENTS_ALL

Line 3088: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

3084: | NOTES:
3085: |
3086: *---------------------------------------------------------------------*/
3087: PROCEDURE initPaymentData(
3088: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
3089: x_payment_rec IN OUT NOCOPY paymentRecType
3090: )
3091: IS
3092:

Line 3101: CURSOR c_payment_rec (p_pay_id IBY_PAYMENTS_ALL.payment_id%TYPE)

3097: * Note: If any field is modified in the query below, the same
3098: * field in 'paymentRecType' record in the spec should be
3099: * modified accordingly.
3100: */
3101: CURSOR c_payment_rec (p_pay_id IBY_PAYMENTS_ALL.payment_id%TYPE)
3102: RETURN paymentRecType IS
3103: SELECT
3104: pay.payment_id pmt_id,
3105: pay.payment_amount pmt_amount,

Line 3120: IBY_PAYMENTS_ALL pay,

3116: payer.party_address_postal_code,
3117: payer_bank_acc.currency_code
3118:
3119: FROM
3120: IBY_PAYMENTS_ALL pay,
3121: IBY_PP_FIRST_PARTY_V payer,
3122: CE_BANK_ACCOUNTS payer_bank_acc
3123: WHERE
3124: pay.payment_id = p_pay_id

Line 3233: from iby_docs_payable_all d, iby_payments_all p

3229: select sum(d.document_amount),
3230: count(d.document_payable_id)
3231: into x_instruction_rec.ins_amount,
3232: x_instruction_rec.ins_document_count
3233: from iby_docs_payable_all d, iby_payments_all p
3234: where p.payment_instruction_id = p_instruction_id
3235: and p.payment_id = d.payment_id
3236:
3237: /*