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.ARP_PROCESS_BR_REMIT dependencies on CE_BANK_BRANCHES_V

Line 92: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

88: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
89: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
92: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
93: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
94: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
95: p_br_sort_criteria IN varchar2,
96: p_br_order IN varchar2,

Line 93: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

89: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
92: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
93: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
94: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
95: p_br_sort_criteria IN varchar2,
96: p_br_order IN varchar2,
97: p_drawee_sort_criteria IN varchar2,

Line 94: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
92: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
93: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
94: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
95: p_br_sort_criteria IN varchar2,
96: p_br_order IN varchar2,
97: p_drawee_sort_criteria IN varchar2,
98: p_drawee_order IN varchar2,

Line 390: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

386: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
387: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
390: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
391: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
392: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
393: p_br_sort_criteria IN varchar2,
394: p_br_order IN varchar2,

Line 391: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

387: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
390: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
391: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
392: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
393: p_br_sort_criteria IN varchar2,
394: p_br_order IN varchar2,
395: p_drawee_sort_criteria IN varchar2,

Line 392: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
390: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
391: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
392: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
393: p_br_sort_criteria IN varchar2,
394: p_br_order IN varchar2,
395: p_drawee_sort_criteria IN varchar2,
396: p_drawee_order IN varchar2,

Line 569: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

565: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
566: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
567: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
568: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
569: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
571: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
572: p_unsigned_flag IN varchar2,
573: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

566: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
567: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
568: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
569: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
571: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
572: p_unsigned_flag IN varchar2,
573: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
574: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

Line 571: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

567: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
568: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
569: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
571: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
572: p_unsigned_flag IN varchar2,
573: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
574: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
575: p_br_sort_criteria IN varchar2,

Line 752: 'CE_BANK_BRANCHES_V BRANCH, ' ||

748: 'HZ_PARTIES PARTY, ' ||
749: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
750: 'RA_CUSTOMER_TRX TRX, ' ||
751: 'AP_BANK_ACCOUNTS ACC, ' ||
752: 'CE_BANK_BRANCHES_V BRANCH, ' ||
753: 'AR_TRANSACTION_HISTORY HS1 ' ||
754: l_where_clause ||
755: l_order_clause;
756:

Line 820: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

816: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
817: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
818: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
819: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
820: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
821: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
822: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
823: p_br_sort_criteria IN varchar2,
824: p_br_order IN varchar2,

Line 821: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

817: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
818: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
819: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
820: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
821: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
822: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
823: p_br_sort_criteria IN varchar2,
824: p_br_order IN varchar2,
825: p_drawee_sort_criteria IN varchar2,

Line 822: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

818: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
819: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
820: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
821: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
822: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
823: p_br_sort_criteria IN varchar2,
824: p_br_order IN varchar2,
825: p_drawee_sort_criteria IN varchar2,
826: p_drawee_order IN varchar2) IS

Line 1379: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

1375: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1376: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1377: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1378: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1379: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1380: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1381: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
1382: p_br_sort_criteria IN varchar2,
1383: p_br_order IN varchar2,

Line 1380: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

1376: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1377: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1378: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1379: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1380: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1381: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
1382: p_br_sort_criteria IN varchar2,
1383: p_br_order IN varchar2,
1384: p_drawee_sort_criteria IN varchar2,

Line 1381: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

1377: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1378: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1379: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1380: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1381: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
1382: p_br_sort_criteria IN varchar2,
1383: p_br_order IN varchar2,
1384: p_drawee_sort_criteria IN varchar2,
1385: p_drawee_order IN varchar2,