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_PROGRAM_BR_REMIT dependencies on CE_BANK_BRANCHES_V

Line 45: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

41: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
42: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
43: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
44: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
45: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
46: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
47: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
48: p_br_sort_criteria IN varchar2,
49: p_br_order IN varchar2,

Line 46: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

42: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
43: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
44: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
45: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
46: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
47: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
48: p_br_sort_criteria IN varchar2,
49: p_br_order IN varchar2,
50: p_drawee_sort_criteria IN varchar2,

Line 47: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

43: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
44: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
45: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
46: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
47: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
48: p_br_sort_criteria IN varchar2,
49: p_br_order IN varchar2,
50: p_drawee_sort_criteria IN varchar2,
51: p_drawee_order IN varchar2);

Line 157: l_drawee_bank_branch_id CE_BANK_BRANCHES_V.branch_party_id%TYPE;

153: l_br_amount_high AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
154: l_transaction_type1_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
155: l_transaction_type2_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;
156: l_drawee_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
157: l_drawee_bank_branch_id CE_BANK_BRANCHES_V.branch_party_id%TYPE;
158:
159: BEGIN
160:
161: -- SSA - R12 : set global variable

Line 326: p_drawee_bank_name IN CE_BANK_BRANCHES_V.bank_name%TYPE,

322: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
323: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
324: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
325: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
326: p_drawee_bank_name IN CE_BANK_BRANCHES_V.bank_name%TYPE,
327: p_drawee_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
328: p_drawee_branch_city IN CE_BANK_BRANCHES_V.city%TYPE,
329: p_br_sort_criteria IN varchar2,
330: p_br_order IN varchar2,

Line 327: p_drawee_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,

323: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
324: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
325: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
326: p_drawee_bank_name IN CE_BANK_BRANCHES_V.bank_name%TYPE,
327: p_drawee_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
328: p_drawee_branch_city IN CE_BANK_BRANCHES_V.city%TYPE,
329: p_br_sort_criteria IN varchar2,
330: p_br_order IN varchar2,
331: p_drawee_sort_criteria IN varchar2,

Line 328: p_drawee_branch_city IN CE_BANK_BRANCHES_V.city%TYPE,

324: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
325: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
326: p_drawee_bank_name IN CE_BANK_BRANCHES_V.bank_name%TYPE,
327: p_drawee_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
328: p_drawee_branch_city IN CE_BANK_BRANCHES_V.city%TYPE,
329: p_br_sort_criteria IN varchar2,
330: p_br_order IN varchar2,
331: p_drawee_sort_criteria IN varchar2,
332: p_drawee_order IN varchar2) IS

Line 819: l_remit_bank ce_bank_branches_v.bank_name%TYPE;

815:
816: l_sort_by varchar2(30);
817: l_sum_or_det varchar2(30);
818: l_include_formatted varchar2(30);
819: l_remit_bank ce_bank_branches_v.bank_name%TYPE;
820: l_remit_bank_branch ce_bank_branches_v.bank_branch_name%TYPE;
821:
822: CURSOR prt_program IS
823: Select program_name

Line 820: l_remit_bank_branch ce_bank_branches_v.bank_branch_name%TYPE;

816: l_sort_by varchar2(30);
817: l_sum_or_det varchar2(30);
818: l_include_formatted varchar2(30);
819: l_remit_bank ce_bank_branches_v.bank_name%TYPE;
820: l_remit_bank_branch ce_bank_branches_v.bank_branch_name%TYPE;
821:
822: CURSOR prt_program IS
823: Select program_name
824: From AP_PAYMENT_PROGRAMS

Line 862: FROM ce_bank_branches_v bank,

858: SELECT bank.bank_name,
859: bank.bank_branch_name
860: INTO l_remit_bank,
861: l_remit_bank_branch
862: FROM ce_bank_branches_v bank,
863: ce_bank_accounts cba,
864: ce_bank_acct_uses cbau
865: WHERE cbau.bank_acct_use_id = l_batch_rec.remit_bank_acct_use_id
866: AND cbau.bank_account_id = cba.bank_account_id