APPS.AP_BANK_CHARGE_PKG dependencies on AP_BANK_CHARGES

Line 119: from ap_bank_charges

115: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
117: END IF;
118: select count(*) into unique_check
119: from ap_bank_charges
120: where transferring_bank_name = P_transferring_bank_name
121: and transferring_branch = P_transferring_branch
122: and receiving_bank_name = P_receiving_bank_name
123: and receiving_branch = P_receiving_branch

Line 133: from ap_bank_charges

129: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
130: END IF;
131:
132: select count(*) into unique_check
133: from ap_bank_charges
134: where transferring_bank_name = P_transferring_bank_name
135: and transferring_branch = P_transferring_branch
136: and receiving_bank = P_receiving_bank
137: and receiving_branch = P_receiving_branch

Line 150: from ap_bank_charges

146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
147: END IF;
148:
149: select count(*) into unique_check
150: from ap_bank_charges
151: where transferring_bank = P_transferring_bank
152: and transferring_branch = P_transferring_branch
153: and receiving_bank_name = P_receiving_bank_name
154: and receiving_branch = P_receiving_branch

Line 164: from ap_bank_charges

160: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
161: END IF;
162:
163: select count(*) into unique_check
164: from ap_bank_charges
165: where transferring_bank = P_transferring_bank
166: and transferring_branch = P_transferring_branch
167: and receiving_bank = P_receiving_bank
168: and receiving_branch = P_receiving_branch

Line 181: from ap_bank_charges

177: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
178: END IF;
179:
180: select count(*) into unique_check
181: from ap_bank_charges
182: where transferring_bank_name = P_transferring_bank_name
183: and transferring_branch = P_transferring_branch
184: and receiving_bank_branch_id = P_receiving_bank_branch_id
185: and transfer_priority = P_transfer_priority

Line 196: from ap_bank_charges

192: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
193: END IF;
194:
195: select count(*) into unique_check
196: from ap_bank_charges
197: where transferring_bank = P_transferring_bank
198: and transferring_branch = P_transferring_branch
199: and receiving_bank_branch_id = P_receiving_bank_branch_id
200: and transfer_priority = P_transfer_priority

Line 215: from ap_bank_charges

211: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
212: END IF;
213:
214: select count(*) into unique_check
215: from ap_bank_charges
216: where transferring_bank_branch_id = P_transferring_bank_branch_id
217: and receiving_bank_name = P_receiving_bank_name
218: and receiving_branch = P_receiving_branch
219: and transfer_priority = P_transfer_priority

Line 229: from ap_bank_charges

225: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
227: END IF;
228: select count(*) into unique_check
229: from ap_bank_charges
230: where transferring_bank_branch_id = P_transferring_bank_branch_id
231: and receiving_bank = P_receiving_bank
232: and receiving_branch = P_receiving_branch
233: and transfer_priority = P_transfer_priority

Line 245: from ap_bank_charges

241: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
242: END IF;
243:
244: select count(*) into unique_check
245: from ap_bank_charges
246: where transferring_bank_branch_id = P_transferring_bank_branch_id
247: and receiving_bank_branch_id = P_receiving_bank_branch_id
248: and transfer_priority = P_transfer_priority
249: and currency_code = P_currency_code

Line 573: FROM ap_bank_charges bc, ap_bank_charge_lines bcl

569: bc.receiving_bank,
570: bc.receiving_branch,
571: bc.transfer_priority,
572: bc.currency_code
573: FROM ap_bank_charges bc, ap_bank_charge_lines bcl
574: WHERE ((bc.transferring_bank_branch_id = X_transferring_bank_branch_id
575: -- bug2242764 added bank_name condition
576: AND bc.transferring_bank_name = X_transferring_bank_name)
577: OR (bc.transferring_bank_name = X_transferring_bank_name

Line 1014: FROM ap_bank_charges bc, ap_bank_charge_lines bcl

1010: bc.receiving_bank,
1011: bc.receiving_branch,
1012: bc.transfer_priority,
1013: bc.currency_code
1014: FROM ap_bank_charges bc, ap_bank_charge_lines bcl
1015: WHERE ((bc.transferring_bank_branch_id = X_transferring_bank_branch_id
1016: -- bug2242764 added bank_name condition
1017: AND transferring_bank_name = X_transferring_bank_name)
1018: OR (bc.transferring_bank_name = X_transferring_bank_name