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_PAYINSTR_PUB dependencies on IBY_PAY_SERVICE_REQUESTS

Line 96: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.

92:
93: /*-- selection criteria --*/
94: p_payment_profile_id IN IBY_PAYMENTS_ALL.
95: payment_profile_id%TYPE,
96: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.
97: calling_app_id%TYPE,
98: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
99: call_app_pay_service_req_code
100: %TYPE,

Line 98: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

94: p_payment_profile_id IN IBY_PAYMENTS_ALL.
95: payment_profile_id%TYPE,
96: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.
97: calling_app_id%TYPE,
98: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
99: call_app_pay_service_req_code
100: %TYPE,
101: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
102: payment_service_request_id

Line 101: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

97: calling_app_id%TYPE,
98: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
99: call_app_pay_service_req_code
100: %TYPE,
101: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
102: payment_service_request_id
103: %TYPE,
104: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.
105: internal_bank_account_id%TYPE,

Line 215: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;

211: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
212: l_errTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
213:
214: /* previous payment attributes */
215: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
216: prev_pmt_id iby_payments_all.payment_id%TYPE;
217: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
218: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
219: prev_int_bank_acct_id iby_payments_all.

Line 235: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;

231: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
232: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
233:
234: /* current payment attributes */
235: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
236: curr_pmt_id iby_payments_all.payment_id%TYPE;
237: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
238: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
239: curr_int_bank_acct_id iby_payments_all.

Line 714: || 'IBY_PAY_SERVICE_REQUESTS prq, '

710: || 'icr.group_by_payment_method '
711: || 'FROM '
712: || 'IBY_PAYMENTS_SEC_V pmts, '
713: || 'IBY_INSTR_CREATION_RULES icr, '
714: || 'IBY_PAY_SERVICE_REQUESTS prq, '
715: || 'IBY_SYS_PMT_PROFILES_B sppf, '
716: || 'IBY_ACCT_PMT_PROFILES_B appf, '
717: || 'HZ_PARTIES branch_party, '
718: || 'HZ_CODE_ASSIGNMENTS rfc_ca, '

Line 6358: || 'IBY_PAY_SERVICE_REQUESTS req, '

6354: || 'NULL, ' /* sequence number */
6355: || 'NULL ' /* sequence id */
6356: || 'FROM '
6357: || 'IBY_PAYMENTS_ALL pmt, '
6358: || 'IBY_PAY_SERVICE_REQUESTS req, '
6359: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
6360: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
6361: || 'HZ_PARTIES payee, '
6362: || 'HZ_LOCATIONS payee_location, '

Line 6397: || 'IBY_PAY_SERVICE_REQUESTS req, '

6393: || 'NULL, ' /* sequence number */
6394: || 'NULL ' /* sequence id */
6395: || 'FROM '
6396: || 'IBY_PAYMENTS_ALL pmt, '
6397: || 'IBY_PAY_SERVICE_REQUESTS req, '
6398: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
6399: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
6400: || 'HZ_PARTIES payee '
6401: || 'WHERE '