DBA Data[Home] [Help]

APPS.CS_SR_DUP_CHK_PVT dependencies on CUG_INCIDNT_ATTR_VALS_VL

Line 500: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl

496:
497: l_DuplicateCheckAttrs_rec l_DuplicateCheckAttrs_csr%ROWTYPE;
498:
499: CURSOR l_OldDupAttrValue_csr (p_inc_id NUMBER) IS
500: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl
501: WHERE sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
502: incident_id = p_inc_Id;
503:
504: CURSOR l_DupAttrValueUpd_csr IS

Line 505: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl

501: WHERE sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
502: incident_id = p_inc_Id;
503:
504: CURSOR l_DupAttrValueUpd_csr IS
505: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl
506: WHERE sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
507: incident_id = l_incident_Id;
508:
509: BEGIN