DBA Data[Home] [Help]

APPS.CS_SR_DUP_CHK_PVT dependencies on CUG_SR_TYPE_DUP_CHK_INFO

Line 223: select SR_DUP_CHECK_FLAG from CUG_SR_TYPE_DUP_CHK_INFO

219: )
220: IS
221:
222: CURSOR c_CheckIfDupCheckOn_csr IS
223: select SR_DUP_CHECK_FLAG from CUG_SR_TYPE_DUP_CHK_INFO
224: WHERE INCIDENT_TYPE_ID = p_incident_type_id;
225: c_CheckIfDupCheckOn_rec c_CheckIfDupCheckOn_csr%ROWTYPE;
226:
227: l_incident_type_id NUMBER := p_incident_type_id;

Line 318: FROM CUG_SR_TYPE_DUP_CHK_INFO

314: l_SRAttribute_value_new varchar2(80);
315:
316: CURSOR c_DuplicateTimeInfo_csr IS
317: SELECT duplicate_offset, duplicate_uom, dup_chk_incident_addr_flag
318: FROM CUG_SR_TYPE_DUP_CHK_INFO
319: WHERE INCIDENT_TYPE_ID = l_incident_type_id;
320: l_DuplicateTimeInfo_rec c_DuplicateTimeInfo_csr%ROWTYPE;
321:
322: CURSOR l_IncidentId_NoAddr_csr IS

Line 1790: SELECT duplicate_offset, duplicate_uom FROM CUG_SR_TYPE_DUP_CHK_INFO

1786: l_incident_type_id NUMBER;
1787: l_multiple_by NUMBER;
1788:
1789: CURSOR c_DuplicateTimeInfo_csr IS
1790: SELECT duplicate_offset, duplicate_uom FROM CUG_SR_TYPE_DUP_CHK_INFO
1791: WHERE INCIDENT_TYPE_ID = l_incident_type_id;
1792: l_DuplicateTimeInfo_rec c_DuplicateTimeInfo_csr%ROWTYPE;
1793:
1794: CURSOR c_UOM_Conversion_Rate_csr IS