APPS.PON_USER_PROFILE_PKG dependencies on POS_SUPPLIER_USERS_V

Line 90: FROM pos_supplier_users_v

86:
87:
88: SELECT vendor_party_id
89: INTO l_vendor_party_id
90: FROM pos_supplier_users_v
91: WHERE person_party_id = l_user_party_id;
92:
93: -- CALL iSP API to update the Supplier Info. They in turn will update the required TCA table.
94: -- iSP package : POS_SUPP_CONTACT_PKG

Line 231: , POS_SUPPLIER_USERS_V posv

227: FROM HZ_PARTIES hp1 -- Person
228: , HZ_CONTACT_POINTS hc1 -- Phone
229: , HZ_CONTACT_POINTS hc3 -- Email
230: , HZ_CONTACT_POINTS hc4 -- Fax
231: , POS_SUPPLIER_USERS_V posv
232: WHERE hp1.party_id = x_user_party_id
233: AND hp1.party_id = posv.person_party_id
234: AND hp1.status = 'A'
235: AND hc1.owner_table_name(+) = 'HZ_PARTIES'

Line 297: , POS_SUPPLIER_USERS_V posv

293: FROM HZ_PARTIES hp1 -- Person
294: , HZ_CONTACT_POINTS hc1 -- Phone
295: , HZ_CONTACT_POINTS hc3 -- Email
296: , HZ_CONTACT_POINTS hc4 -- Fax
297: , POS_SUPPLIER_USERS_V posv
298: WHERE hp1.party_id = x_user_party_id
299: AND hp1.party_id = posv.person_party_id
300: AND hp1.status = 'A'
301: AND hc1.owner_table_name(+) = 'HZ_PARTIES'