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 HZ_CUST_ACCOUNTS

Line 40: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

36: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
37: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
38: p_include_unpaid_flag IN varchar2,
39: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
40: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 41: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

37: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
38: p_include_unpaid_flag IN varchar2,
39: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
40: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 42: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

38: p_include_unpaid_flag IN varchar2,
39: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
40: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 43: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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

Line 44: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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

Line 321: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

317: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
318: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
319: p_include_unpaid_flag IN varchar2,
320: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
321: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 322: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

318: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
319: p_include_unpaid_flag IN varchar2,
320: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
321: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 323: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

319: p_include_unpaid_flag IN varchar2,
320: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
321: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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,

Line 324: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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

Line 325: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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

Line 1081: hz_cust_accounts hca,

1077: br.drawee_id,
1078: br.drawee_site_use_id,
1079: br.payment_trxn_extension_id
1080: FROM ra_customer_trx br,
1081: hz_cust_accounts hca,
1082: hz_parties party
1083: WHERE br.remittance_batch_id = p_batch_id
1084: and hca.party_id = party.party_id
1085: and hca.cust_account_id = br.drawee_id ;