APPS.POS_VENDOR_REG_PKG dependencies on POS_SUPP_PROF_EXT_B

Line 922: UPDATE pos_supp_prof_ext_b

918: AND data_level_name = 'SUPP_ADDR_LEVEL';
919:
920: -- update party level UDAs
921:
922: UPDATE pos_supp_prof_ext_b
923: SET is_prospect = 'N',
924: party_id = p_party_id
925: WHERE is_prospect = 'Y'
926: AND party_id = p_supplier_reg_id

Line 940: UPDATE pos_supp_prof_ext_b

936: -- update party site UDAs
937:
938: FOR l_rec IN l_cur LOOP
939:
940: UPDATE pos_supp_prof_ext_b
941: SET is_prospect = 'N',
942: party_id = p_party_id,
943: pk1_value = l_rec.party_site_id
944: WHERE is_prospect = 'Y'