DBA Data[Home] [Help]

APPS.POS_VENDOR_REG_PKG dependencies on POS_SUPP_PROF_EXT_TL

Line 929: UPDATE pos_supp_prof_ext_tl

925: WHERE is_prospect = 'Y'
926: AND party_id = p_supplier_reg_id
927: AND data_level_id = l_supp_level_id;
928:
929: UPDATE pos_supp_prof_ext_tl
930: SET is_prospect = 'N',
931: party_id = p_party_id
932: WHERE is_prospect = 'Y'
933: AND party_id = p_supplier_reg_id

Line 949: UPDATE pos_supp_prof_ext_tl

945: AND party_id = p_supplier_reg_id
946: AND pk1_value = l_rec.address_request_id
947: AND data_level_id = l_supp_addr_level_id;
948:
949: UPDATE pos_supp_prof_ext_tl
950: SET is_prospect = 'N',
951: party_id = p_party_id,
952: pk1_value = l_rec.party_site_id
953: WHERE is_prospect = 'Y'