APPS.IBY_EXT_PAYEE_RELSHIPS_PKG dependencies on IBY_EXT_PAYEE_RELATIONSHIPS

Line 41: FROM iby_ext_payee_relationships irel

37: INTO
38: x_relationship_id,
39: x_remit_party_id,
40: x_remit_supplier_site_id
41: FROM iby_ext_payee_relationships irel
42: WHERE party_id = p_party_id
43: AND supplier_site_id = p_supplier_site_id
44: AND primary_flag = 'Y'
45: AND active = 'Y'

Line 107: FROM iby_ext_payee_relationships irel

103: INTO
104: x_relationship_id,
105: x_remit_party_id,
106: x_remit_supplier_site_id
107: FROM iby_ext_payee_relationships irel
108: WHERE party_id = p_party_id
109: AND supplier_site_id = p_supplier_site_id
110: AND active = 'Y'
111: AND primary_flag = 'Y'

Line 139: FROM iby_ext_payee_relationships irel

135: remit_party_id
136: INTO
137: x_relationship_id,
138: x_remit_party_id
139: FROM iby_ext_payee_relationships irel
140: WHERE party_id = p_party_id
141: AND supplier_site_id = p_supplier_site_id
142: AND remit_supplier_site_id = x_remit_supplier_site_id
143: AND active = 'Y'

Line 157: FROM iby_ext_payee_relationships irel

153:
154: print_debuginfo('2 Primary Relationship not found');
155: SELECT count(*)
156: INTO p_count
157: FROM iby_ext_payee_relationships irel
158: WHERE party_id = p_party_id
159: AND supplier_site_id = p_supplier_site_id
160: AND remit_supplier_site_id = x_remit_supplier_site_id
161: AND active = 'Y'

Line 193: FROM iby_ext_payee_relationships irel

189: remit_supplier_site_id
190: INTO
191: x_relationship_id,
192: x_remit_supplier_site_id
193: FROM iby_ext_payee_relationships irel
194: WHERE party_id = p_party_id
195: AND supplier_site_id = p_supplier_site_id
196: AND remit_party_id = x_remit_party_id
197: AND active = 'Y'

Line 210: FROM iby_ext_payee_relationships irel

206: print_debuginfo('3 Primary Relationship not found');
207: IF ( x_remit_party_id <> p_party_id ) THEN
208: SELECT count(*)
209: INTO p_count
210: FROM iby_ext_payee_relationships irel
211: WHERE party_id = p_party_id
212: AND supplier_site_id = p_supplier_site_id
213: AND remit_party_id = x_remit_party_id
214: AND active = 'Y'

Line 244: FROM iby_ext_payee_relationships irel

240: SELECT
241: relationship_id
242: INTO
243: x_relationship_id
244: FROM iby_ext_payee_relationships irel
245: WHERE party_id = p_party_id
246: AND supplier_site_id = p_supplier_site_id
247: AND remit_party_id = x_remit_party_id
248: AND remit_supplier_site_id = x_remit_supplier_site_id

Line 262: FROM iby_ext_payee_relationships irel

258: print_debuginfo('4 Primary Relationship not found');
259:
260: SELECT count(*)
261: INTO p_count
262: FROM iby_ext_payee_relationships irel
263: WHERE party_id = p_party_id
264: AND supplier_site_id = p_supplier_site_id
265: AND remit_party_id = x_remit_party_id
266: AND remit_supplier_site_id = x_remit_supplier_site_id

Line 300: FROM iby_ext_payee_relationships irel

296: remit_supplier_site_id
297: INTO
298: x_remit_party_id,
299: x_remit_supplier_site_id
300: FROM iby_ext_payee_relationships irel
301: WHERE party_id = p_party_id
302: AND supplier_site_id = p_supplier_site_id
303: AND active = 'Y'
304: AND relationship_id = x_relationship_id

Line 327: FROM iby_ext_payee_relationships irel

323: SELECT
324: remit_party_id
325: INTO
326: x_remit_party_id
327: FROM iby_ext_payee_relationships irel
328: WHERE party_id = p_party_id
329: AND supplier_site_id = p_supplier_site_id
330: AND remit_supplier_site_id = x_remit_supplier_site_id
331: AND active = 'Y'

Line 358: FROM iby_ext_payee_relationships irel

354: SELECT
355: remit_supplier_site_id
356: INTO
357: x_remit_supplier_site_id
358: FROM iby_ext_payee_relationships irel
359: WHERE party_id = p_party_id
360: AND supplier_site_id = p_supplier_site_id
361: AND remit_party_id = x_remit_party_id
362: AND active = 'Y'

Line 387: FROM iby_ext_payee_relationships irel

383: SELECT
384: relationship_id
385: INTO
386: x_relationship_id
387: FROM iby_ext_payee_relationships irel
388: WHERE party_id = p_party_id
389: AND supplier_site_id = p_supplier_site_id
390: AND remit_party_id = x_remit_party_id
391: AND remit_supplier_site_id = x_remit_supplier_site_id