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

Line 497: ce_bank_branches_v bp /Bug3348454/

493: ar_receipt_method_accounts arma,
494: ce_bank_acct_uses_all aba,
495: ce_bank_accounts cba,
496: ar_receipt_classes arc,
497: ce_bank_branches_v bp /*Bug3348454*/
498: WHERE arm.receipt_method_id = rcrm.receipt_method_id
499: AND arm.receipt_method_id = arma.receipt_method_id
500: AND arm.receipt_class_id = arc.receipt_class_id
501: AND rcrm.customer_id = p_customer_id

Line 719: ce_bank_branches_v.bank_name%type,

715: ce_bank_accounts.bank_account_id%type,
716: p_bank_account_num OUT NOCOPY
717: ce_bank_accounts.bank_account_num%type,
718: p_bank_name OUT NOCOPY
719: ce_bank_branches_v.bank_name%type,
720: p_bank_branch_name OUT NOCOPY
721: ce_bank_branches_v.bank_branch_name%type,
722: p_bank_branch_id OUT NOCOPY
723: ce_bank_branches_v.branch_party_id%TYPE

Line 721: ce_bank_branches_v.bank_branch_name%type,

717: ce_bank_accounts.bank_account_num%type,
718: p_bank_name OUT NOCOPY
719: ce_bank_branches_v.bank_name%type,
720: p_bank_branch_name OUT NOCOPY
721: ce_bank_branches_v.bank_branch_name%type,
722: p_bank_branch_id OUT NOCOPY
723: ce_bank_branches_v.branch_party_id%TYPE
724: ) RETURN BOOLEAN IS
725:

Line 723: ce_bank_branches_v.branch_party_id%TYPE

719: ce_bank_branches_v.bank_name%type,
720: p_bank_branch_name OUT NOCOPY
721: ce_bank_branches_v.bank_branch_name%type,
722: p_bank_branch_id OUT NOCOPY
723: ce_bank_branches_v.branch_party_id%TYPE
724: ) RETURN BOOLEAN IS
725:
726:
727: l_customer_bank_account_id

Line 730: l_bank_name ce_bank_branches_v.bank_name%type;

726:
727: l_customer_bank_account_id
728: ce_bank_accounts.bank_account_id%type;
729: l_bank_account_num ce_bank_accounts.bank_account_num%type;
730: l_bank_name ce_bank_branches_v.bank_name%type;
731: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
732: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
733:
734:

Line 731: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;

727: l_customer_bank_account_id
728: ce_bank_accounts.bank_account_id%type;
729: l_bank_account_num ce_bank_accounts.bank_account_num%type;
730: l_bank_name ce_bank_branches_v.bank_name%type;
731: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
732: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
733:
734:
735: BEGIN

Line 732: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;

728: ce_bank_accounts.bank_account_id%type;
729: l_bank_account_num ce_bank_accounts.bank_account_num%type;
730: l_bank_name ce_bank_branches_v.bank_name%type;
731: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
732: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
733:
734:
735: BEGIN
736:

Line 1010: ce_bank_branches_v.bank_name%type,

1006: ce_bank_accounts.bank_account_id%type,
1007: p_bank_account_num OUT NOCOPY
1008: ce_bank_accounts.bank_account_num%type,
1009: p_bank_name OUT NOCOPY
1010: ce_bank_branches_v.bank_name%type,
1011: p_bank_branch_name OUT NOCOPY
1012: ce_bank_branches_v.bank_branch_name%type,
1013: p_bank_branch_id OUT NOCOPY
1014: ce_bank_branches_v.branch_party_id%TYPE,

Line 1012: ce_bank_branches_v.bank_branch_name%type,

1008: ce_bank_accounts.bank_account_num%type,
1009: p_bank_name OUT NOCOPY
1010: ce_bank_branches_v.bank_name%type,
1011: p_bank_branch_name OUT NOCOPY
1012: ce_bank_branches_v.bank_branch_name%type,
1013: p_bank_branch_id OUT NOCOPY
1014: ce_bank_branches_v.branch_party_id%TYPE,
1015: p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
1016: ) IS

Line 1014: ce_bank_branches_v.branch_party_id%TYPE,

1010: ce_bank_branches_v.bank_name%type,
1011: p_bank_branch_name OUT NOCOPY
1012: ce_bank_branches_v.bank_branch_name%type,
1013: p_bank_branch_id OUT NOCOPY
1014: ce_bank_branches_v.branch_party_id%TYPE,
1015: p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
1016: ) IS
1017:
1018:

Line 1047: from ce_bank_branches_v.. */

1043: END IF;
1044:
1045: /* check first to see if the payment type is a credit card. If it
1046: is then we want to default bank_name and branch_name fields
1047: from ce_bank_branches_v.. */
1048:
1049: IF ( NVL(p_payment_type_code,'-1') = 'CREDIT_CARD' ) THEN
1050: IF PG_DEBUG in ('Y', 'C') THEN
1051: arp_util.debug('get_bank_defaults: ' || 'Defaulting parameters for Credit Card Type ');

Line 1062: ce_bank_branches_v abb

1058: p_bank_name,
1059: p_bank_branch_name,
1060: p_bank_branch_id
1061: FROM
1062: ce_bank_branches_v abb
1063: WHERE
1064: abb.branch_party_id = arp_global.CC_BANK_BRANCH_ID;
1065:
1066: RETURN;

Line 1263: ce_bank_branches_v.bank_name%type,

1259: ce_bank_accounts.bank_account_id%type,
1260: p_bank_account_num OUT NOCOPY
1261: ce_bank_accounts.bank_account_num%type,
1262: p_bank_name OUT NOCOPY
1263: ce_bank_branches_v.bank_name%type,
1264: p_bank_branch_name OUT NOCOPY
1265: ce_bank_branches_v.bank_branch_name%type,
1266: p_bank_branch_id OUT NOCOPY
1267: ce_bank_branches_v.branch_party_id%TYPE,

Line 1265: ce_bank_branches_v.bank_branch_name%type,

1261: ce_bank_accounts.bank_account_num%type,
1262: p_bank_name OUT NOCOPY
1263: ce_bank_branches_v.bank_name%type,
1264: p_bank_branch_name OUT NOCOPY
1265: ce_bank_branches_v.bank_branch_name%type,
1266: p_bank_branch_id OUT NOCOPY
1267: ce_bank_branches_v.branch_party_id%TYPE,
1268: p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
1269: ) IS

Line 1267: ce_bank_branches_v.branch_party_id%TYPE,

1263: ce_bank_branches_v.bank_name%type,
1264: p_bank_branch_name OUT NOCOPY
1265: ce_bank_branches_v.bank_branch_name%type,
1266: p_bank_branch_id OUT NOCOPY
1267: ce_bank_branches_v.branch_party_id%TYPE,
1268: p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
1269: ) IS
1270:
1271: