APPS.PRP_IBC_INT_PVT dependencies on PRP_PROPOSALS

Line 42: FROM PRP_PROPOSALS

38: WHERE comp_style_ctntver_id = p_comp_style_ctntver_id;
39:
40: CURSOR Cur_Proposals(p_proposal_id NUMBER) IS
41: SELECT Proposal_Name
42: FROM PRP_PROPOSALS
43: WHERE PROPOSAL_ID = p_proposal_id;
44:
45: CURSOR Cur_Proposal_ctntvers(p_proposal_ctntver_id NUMBER) IS
46: SELECT proposal_name

Line 47: FROM prp_proposals pp, prp_proposal_ctntvers ppc

43: WHERE PROPOSAL_ID = p_proposal_id;
44:
45: CURSOR Cur_Proposal_ctntvers(p_proposal_ctntver_id NUMBER) IS
46: SELECT proposal_name
47: FROM prp_proposals pp, prp_proposal_ctntvers ppc
48: WHERE pp.proposal_id = ppc.proposal_id
49: AND ppc.PROPOSAL_CTNTVER_ID = p_proposal_ctntver_id;
50:
51: CURSOR Cur_Perz_Files(p_perz_file_id NUMBER) IS

Line 53: FROM prp_proposals pp, prp_perz_files ppf, prp_prop_style_ctntvers pps

49: AND ppc.PROPOSAL_CTNTVER_ID = p_proposal_ctntver_id;
50:
51: CURSOR Cur_Perz_Files(p_perz_file_id NUMBER) IS
52: SELECT proposal_name
53: FROM prp_proposals pp, prp_perz_files ppf, prp_prop_style_ctntvers pps
54: WHERE pp.proposal_id = pps.proposal_id
55: AND pps.OBJECT_ID = ppf.perz_file_id
56: AND ppf.perz_file_id = p_perz_file_id;
57: