APPS.PRP_RTTAP_INT_PVT dependencies on PRP_TERRITORY_ACCESSES

Line 650: DELETE FROM PRP_TERRITORY_ACCESSES TACC

646: | combinations is very complex and could be slow..
647: +-------------------------------------------------------------------------------*/
648: x_return_status := FND_API.G_RET_STS_SUCCESS;
649:
650: DELETE FROM PRP_TERRITORY_ACCESSES TACC
651: WHERE TACC.proposal_access_id IN
652: (SELECT ACC.proposal_access_id
653: FROM PRP_PROPOSAL_ACCESSES ACC
654: WHERE proposal_id = G_PROPOSAL_ID);

Line 661: INSERT INTO PRP_TERRITORY_ACCESSES

657: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
658:
659: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' THEN
660:
661: INSERT INTO PRP_TERRITORY_ACCESSES
662: (proposal_access_id,
663: territory_id,
664: object_version_number,
665: last_update_date,

Line 684: FROM PRP_TERRITORY_ACCESSES

680: WHERE ACC.proposal_id = G_PROPOSAL_ID
681: AND ACC.resource_id = p_WinningTerrMember_tbl.resource_id(l_index)
682: AND ACC.resource_group_id = p_WinningTerrMember_tbl.group_id(l_index)
683: AND NOT EXISTS ( SELECT 'Y'
684: FROM PRP_TERRITORY_ACCESSES
685: WHERE proposal_ACCESS_ID = ACC.Proposal_access_id
686: AND TERRITORY_ID = p_WinningTerrMember_tbl.terr_id(l_index)) ;
687: END IF;
688: END LOOP;