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 HZ_CUST_ACCOUNTS

Line 87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

83: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
84: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
85: p_include_unpaid_flag IN varchar2,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 88: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

84: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
85: p_include_unpaid_flag IN varchar2,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 89: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

85: p_include_unpaid_flag IN varchar2,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

381: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
382: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
383: p_include_unpaid_flag IN varchar2,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 386: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

382: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
383: p_include_unpaid_flag IN varchar2,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 387: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

383: p_include_unpaid_flag IN varchar2,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 566: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

562: +===========================================================================*/
563: PROCEDURE construct_select_br_for_remit (
564: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%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,

Line 567: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

563: PROCEDURE construct_select_br_for_remit (
564: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%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,

Line 568: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

564: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%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,

Line 747: 'HZ_CUST_ACCOUNTS CUST, ' ||

743:
744: p_select_detail := 'SELECT PS.* ' ||
745: 'FROM AR_PAYMENT_SCHEDULES PS, ' ||
746: 'AR_TRANSACTION_HISTORY HS, ' ||
747: 'HZ_CUST_ACCOUNTS CUST, ' ||
748: 'HZ_PARTIES PARTY, ' ||
749: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
750: 'RA_CUSTOMER_TRX TRX, ' ||
751: 'AP_BANK_ACCOUNTS ACC, ' ||

Line 815: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

811: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
812: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
813: p_include_unpaid_flag IN varchar2,
814: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
815: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 816: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

812: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
813: p_include_unpaid_flag IN varchar2,
814: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
815: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 817: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

813: p_include_unpaid_flag IN varchar2,
814: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
815: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 818: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

814: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
815: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 819: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

815: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 1040: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

1036: p_unsigned_flag IN varchar2,
1037: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1038: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1039: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1040: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1041: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1042: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1043: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1044:

Line 1041: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

1037: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1038: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1039: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1040: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1041: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1042: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1043: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1044:
1045: CUR_BR CUR_TYP;

Line 1374: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

1370: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1371: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1372: p_include_unpaid_flag IN varchar2,
1373: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1374: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 1375: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

1371: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1372: p_include_unpaid_flag IN varchar2,
1373: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1374: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 1376: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

1372: p_include_unpaid_flag IN varchar2,
1373: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1374: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 1377: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

1373: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1374: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 1378: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

1374: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,