APPS.PRP_IBC_INT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

SELECT PCS.component_style_name,PCS.content_node_type
FROM PRP_COMPONENT_STYLES_VL PCS
WHERE PCS.component_style_id = p_component_style_id;

Line: 26

SELECT ICV.Content_Item_Name
FROM IBC_CITEM_VERSIONS_VL ICV,
     IBC_CONTENT_ITEMS ICI,
     IBC_ASSOCIATIONS IBA
WHERE IBA.ASSOCIATION_TYPE_CODE = P_ASSOCIATION_TYPE_CODE
AND IBA.ASSOCIATED_OBJECT_VAL1 = p_component_style_id
AND ICI.CONTENT_ITEM_ID = IBA.CONTENT_ITEM_ID
AND ICV.CITEM_VERSION_ID = ICI.LIVE_CITEM_VERSION_ID;

Line: 36

SELECT component_style_id
FROM prp_comp_style_ctntvers
WHERE comp_style_ctntver_id = p_comp_style_ctntver_id;

Line: 41

SELECT Proposal_Name
FROM PRP_PROPOSALS
WHERE PROPOSAL_ID = p_proposal_id;

Line: 46

SELECT proposal_name
FROM prp_proposals pp, prp_proposal_ctntvers ppc
WHERE pp.proposal_id = ppc.proposal_id
AND ppc.PROPOSAL_CTNTVER_ID = p_proposal_ctntver_id;

Line: 52

SELECT proposal_name
FROM prp_proposals pp, prp_perz_files ppf, prp_prop_style_ctntvers pps
WHERE pp.proposal_id = pps.proposal_id
AND pps.OBJECT_ID = ppf.perz_file_id
AND ppf.perz_file_id = p_perz_file_id;