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,
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,
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,
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,
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,
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,
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,
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,
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,
738: 'HZ_PARTIES PARTY, ' ||
739: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
740: 'RA_CUSTOMER_TRX TRX, ' ||
741: 'AP_BANK_ACCOUNTS ACC, ' ||
742: 'CE_BANK_BRANCHES_V BRANCH ' ||
743: l_where_clause ||
744: l_order_clause;
745:
746: IF PG_DEBUG in ('Y', 'C') THEN
805: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
806: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
807: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
808: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
809: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
810: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
811: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
812: p_br_sort_criteria IN varchar2,
813: p_br_order IN varchar2,
806: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
807: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
808: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
809: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
810: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
811: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
812: p_br_sort_criteria IN varchar2,
813: p_br_order IN varchar2,
814: p_drawee_sort_criteria IN varchar2,
807: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
808: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
809: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
810: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
811: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
812: p_br_sort_criteria IN varchar2,
813: p_br_order IN varchar2,
814: p_drawee_sort_criteria IN varchar2,
815: p_drawee_order IN varchar2) IS
1364: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1365: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1366: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1367: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1368: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1369: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1370: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
1371: p_br_sort_criteria IN varchar2,
1372: p_br_order IN varchar2,
1365: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1366: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1367: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1368: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1369: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1370: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
1371: p_br_sort_criteria IN varchar2,
1372: p_br_order IN varchar2,
1373: p_drawee_sort_criteria IN varchar2,
1366: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1367: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1368: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1369: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1370: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
1371: p_br_sort_criteria IN varchar2,
1372: p_br_order IN varchar2,
1373: p_drawee_sort_criteria IN varchar2,
1374: p_drawee_order IN varchar2,