APPS.PV_ASSIGNMENT_PUB dependencies on AS_ACCESSES_ALL

Line 195: from as_accesses_all

191: -- Start : Rivendell changes
192: cursor lc_get_access_details ( pc_lead_id NUMBER)
193: is
194: select partner_customer_id, prm_keep_flag
195: from as_accesses_all
196: where lead_id = pc_lead_id;
197: -- End : Rivendell changes
198:
199: -- changin the cursor to check if the partner is inactive or not.

Line 610: update as_accesses_all set prm_keep_flag = 'Y'

606: for i in 1 .. p_partner_id_tbl.count loop
607:
608: if p_partner_id_tbl(i) = l_access_pt_id then
609:
610: update as_accesses_all set prm_keep_flag = 'Y'
611: where partner_customer_id = l_access_pt_id
612: and lead_id = p_lead_id;
613:
614: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 681: UPDATE as_accesses_all

677: ELSE
678: IF l_partner_id_tbl(i) = l_access_pt_id THEN
679:
680: IF l_prm_keep_flag IS NULL OR l_prm_keep_flag = 'N' THEN
681: UPDATE as_accesses_all
682: SET prm_keep_flag = 'Y'
683: WHERE partner_customer_id = l_access_pt_id
684: AND lead_id = p_lead_id;
685: