APPS.PRP_RTTAP_INT_PVT dependencies on PRP_PROPOSALS

Line 611: FROM PRP_PROPOSALS pp

607: p_WinningTerrMember_tbl.resource_id(l_index),
608: p_WinningTerrMember_tbl.group_id(l_index),
609: DECODE(p_WinningTerrMember_tbl.full_access_flag(l_index),'Y','FULL','READ'),
610: 'N'
611: FROM PRP_PROPOSALS pp
612: WHERE pp.proposal_id = G_Proposal_ID
613: AND NOT EXISTS
614: ( SELECT NULL FROM PRP_PROPOSAL_ACCESSES ACC
615: WHERE ACC.proposal_id = pp.proposal_id