APPS.IBY_SUPP_BANK_MERGE_PUB dependencies on IBY_ACCOUNT_OWNERS

Line 37: FROM iby_account_owners

33: WHERE ext_pmt_party_id = cp_ext_payee_id;
34:
35: CURSOR cur_is_ownership_exists(cp_to_party_id IN NUMBER, cp_bank_act_id IN NUMBER) IS
36: SELECT 'Y'
37: FROM iby_account_owners
38: WHERE account_owner_party_id = cp_to_party_id
39: AND ext_bank_account_id = cp_bank_act_id
40: AND NVL(end_date,SYSDATE) > = SYSDATE;
41:

Line 44: FROM iby_account_owners

40: AND NVL(end_date,SYSDATE) > = SYSDATE;
41:
42: CURSOR cur_get_primary_ownership (cp_from_party_id IN NUMBER, cp_bank_act_id IN NUMBER) IS
43: SELECT Primary_flag
44: FROM iby_account_owners
45: WHERE ext_bank_account_id = cp_bank_act_id
46: AND account_owner_party_id = cp_from_party_id
47: AND NVL (end_date, Sysdate) >= Sysdate;
48:

Line 227: UPDATE iby_account_owners

223: g_mesg := ' From Supplier is Primary and To Supplier Ownership Exists ' ;
224: fnd_file.put_line(fnd_file.log, g_mesg);
225: END IF;
226:
227: UPDATE iby_account_owners
228: SET primary_flag = 'N'
229: WHERE ext_bank_account_id = from_bank_account_id_list(I)
230: AND account_owner_party_id = p_from_party_id;
231:

Line 232: UPDATE iby_account_owners

228: SET primary_flag = 'N'
229: WHERE ext_bank_account_id = from_bank_account_id_list(I)
230: AND account_owner_party_id = p_from_party_id;
231:
232: UPDATE iby_account_owners
233: SET primary_flag = 'Y'
234: WHERE ext_bank_account_id = from_bank_account_id_list(I)
235: AND account_owner_party_id = P_to_party_id;
236:

Line 243: UPDATE iby_account_owners

239: g_mesg := ' From Supplier is Primary and To Supplier Ownership Does not Exist ' ;
240: fnd_file.put_line(fnd_file.log, g_mesg);
241: END IF;
242:
243: UPDATE iby_account_owners
244: SET primary_flag = 'N'
245: WHERE ext_bank_account_id = from_bank_account_id_list(I)
246: AND account_owner_party_id = p_from_party_id;
247:

Line 248: INSERT INTO iby_account_owners(

244: SET primary_flag = 'N'
245: WHERE ext_bank_account_id = from_bank_account_id_list(I)
246: AND account_owner_party_id = p_from_party_id;
247:
248: INSERT INTO iby_account_owners(
249: ACCOUNT_OWNER_ID ,
250: EXT_BANK_ACCOUNT_ID ,
251: ACCOUNT_OWNER_PARTY_ID ,
252: END_DATE ,

Line 261: IBY_ACCOUNT_OWNERS_S.NEXTVAL ,

257: LAST_UPDATE_DATE ,
258: LAST_UPDATE_LOGIN ,
259: OBJECT_VERSION_NUMBER
260: )VALUES(
261: IBY_ACCOUNT_OWNERS_S.NEXTVAL ,
262: from_bank_account_id_list(I) ,
263: P_to_party_id ,
264: NULL ,
265: 'Y' ,

Line 279: INSERT INTO iby_account_owners(

275: g_mesg := ' From Supplier is non Primary and To Supplier Ownership Does not Exist ' ;
276: fnd_file.put_line(fnd_file.log, g_mesg);
277: END IF;
278:
279: INSERT INTO iby_account_owners(
280: ACCOUNT_OWNER_ID ,
281: EXT_BANK_ACCOUNT_ID ,
282: ACCOUNT_OWNER_PARTY_ID ,
283: END_DATE ,

Line 292: IBY_ACCOUNT_OWNERS_S.NEXTVAL ,

288: LAST_UPDATE_DATE ,
289: LAST_UPDATE_LOGIN ,
290: OBJECT_VERSION_NUMBER
291: )VALUES(
292: IBY_ACCOUNT_OWNERS_S.NEXTVAL ,
293: from_bank_account_id_list(I) ,
294: P_to_party_id ,
295: NULL ,
296: 'N' ,

Line 311: INSERT INTO iby_account_owners(

307: g_mesg := ' To Supplier Ownership Does not Exist ' ;
308: fnd_file.put_line(fnd_file.log, g_mesg);
309: END IF;
310:
311: INSERT INTO iby_account_owners(
312: ACCOUNT_OWNER_ID ,
313: EXT_BANK_ACCOUNT_ID ,
314: ACCOUNT_OWNER_PARTY_ID ,
315: END_DATE ,

Line 324: IBY_ACCOUNT_OWNERS_S.NEXTVAL ,

320: LAST_UPDATE_DATE ,
321: LAST_UPDATE_LOGIN ,
322: OBJECT_VERSION_NUMBER
323: )VALUES(
324: IBY_ACCOUNT_OWNERS_S.NEXTVAL ,
325: from_bank_account_id_list(I) ,
326: P_to_party_id ,
327: NULL ,
328: 'N' ,