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.AP_BANK_CHARGE_PKG dependencies on CE_BANK_BRANCHES_V

Line 28: FROM ce_bank_branches_v

24: P_bank_number IN OUT NOCOPY VARCHAR2) IS
25:
26: CURSOR C_bank(X_bank_name VARCHAR2)IS
27: SELECT bank_number
28: FROM ce_bank_branches_v
29: WHERE bank_name = X_bank_name;
30:
31: l_debug_info Varchar2(2000);
32: l_api_name CONSTANT VARCHAR2(100) := 'GET_BANK_NUMBER';

Line 65: from ce_bank_branches_v

61: END IF;
62:
63: select bank_number, branch_number, bank_branch_name
64: into P_bank_number, P_branch_number, P_branch_name
65: from ce_bank_branches_v
66: where branch_party_id = p_bank_branch_id;
67:
68: exception
69: when NO_DATA_FOUND then

Line 600: FROM ce_bank_branches_v

596:
597:
598: CURSOR C_get_bank_name(X_bank_branch_id NUMBER) IS
599: SELECT bank_name
600: FROM ce_bank_branches_v
601: WHERE branch_party_id = X_bank_branch_id;
602:
603: CURSOR C_precision(X_currency_code VARCHAR2) IS
604: SELECT precision

Line 624: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;

620: ORDER BY trans_amount_from desc;
621:
622:
623: P_bank_charge_id NUMBER;
624: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;
625: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
626:
627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;

Line 625: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;

621:
622:
623: P_bank_charge_id NUMBER;
624: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;
625: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
626:
627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;
629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;

625: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
626:
627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;
629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;

626:
627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;
629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;

Line 631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;

627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;
629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;

Line 633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;

629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
636: v_transfer_priority VARCHAR2(30);
637: v_currency_code VARCHAR2(15);

Line 634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;

630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
636: v_transfer_priority VARCHAR2(30);
637: v_currency_code VARCHAR2(15);
638:

Line 635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;

631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
636: v_transfer_priority VARCHAR2(30);
637: v_currency_code VARCHAR2(15);
638:
639: priority NUMBER;

Line 1040: FROM ce_bank_branches_v

1036: to_date('31-12-4712', 'DD-MM-YYYY')) > P_transaction_date;
1037:
1038: CURSOR C_get_bank_name(X_bank_branch_id NUMBER) IS
1039: SELECT bank_name
1040: FROM ce_bank_branches_v
1041: WHERE branch_party_id = X_bank_branch_id;
1042:
1043: CURSOR C_precision(X_currency_code VARCHAR2) IS
1044: SELECT precision

Line 1064: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;

1060: ORDER BY trans_amount_from desc;
1061:
1062:
1063: P_bank_charge_id NUMBER;
1064: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;
1065: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
1066:
1067: v_bank_charge_id NUMBER;
1068: v_trans_bank_branch_id NUMBER;

Line 1065: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;

1061:
1062:
1063: P_bank_charge_id NUMBER;
1064: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;
1065: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
1066:
1067: v_bank_charge_id NUMBER;
1068: v_trans_bank_branch_id NUMBER;
1069: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 1069: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;

1065: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
1066:
1067: v_bank_charge_id NUMBER;
1068: v_trans_bank_branch_id NUMBER;
1069: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
1070: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1071: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1072: v_recei_bank_branch_id NUMBER;
1073: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 1070: v_trans_bank ce_bank_branches_v.bank_name%TYPE;

1066:
1067: v_bank_charge_id NUMBER;
1068: v_trans_bank_branch_id NUMBER;
1069: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
1070: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1071: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1072: v_recei_bank_branch_id NUMBER;
1073: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1074: v_recei_bank ce_bank_branches_v.bank_name%TYPE;

Line 1071: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;

1067: v_bank_charge_id NUMBER;
1068: v_trans_bank_branch_id NUMBER;
1069: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
1070: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1071: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1072: v_recei_bank_branch_id NUMBER;
1073: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1074: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
1075: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;

Line 1073: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;

1069: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
1070: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1071: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1072: v_recei_bank_branch_id NUMBER;
1073: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1074: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
1075: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
1076: v_transfer_priority VARCHAR2(30);
1077: v_currency_code VARCHAR2(15);

Line 1074: v_recei_bank ce_bank_branches_v.bank_name%TYPE;

1070: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1071: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1072: v_recei_bank_branch_id NUMBER;
1073: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1074: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
1075: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
1076: v_transfer_priority VARCHAR2(30);
1077: v_currency_code VARCHAR2(15);
1078:

Line 1075: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;

1071: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1072: v_recei_bank_branch_id NUMBER;
1073: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1074: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
1075: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
1076: v_transfer_priority VARCHAR2(30);
1077: v_currency_code VARCHAR2(15);
1078:
1079: priority NUMBER;