DBA Data[Home] [Help]

APPS.CS_SR_DUP_CHK_PVT dependencies on CUG_INCIDNT_ATTR_VALS_VL

Line 484: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl

480:
481: l_DuplicateCheckAttrs_rec l_DuplicateCheckAttrs_csr%ROWTYPE;
482:
483: CURSOR l_OldDupAttrValue_csr (p_inc_id NUMBER) IS
484: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl
485: WHERE sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
486: incident_id = p_inc_Id;
487:
488: CURSOR l_DupAttrValueUpd_csr IS

Line 489: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl

485: WHERE sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
486: incident_id = p_inc_Id;
487:
488: CURSOR l_DupAttrValueUpd_csr IS
489: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl
490: WHERE sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
491: incident_id = l_incident_Id;
492:
493: BEGIN