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 1852: SELECT duplicate_offset, duplicate_uom FROM CUG_SR_TYPE_DUP_CHK_INFO

1848: l_incident_type_id NUMBER;
1849: l_multiple_by NUMBER;
1850:
1851: CURSOR c_DuplicateTimeInfo_csr IS
1852: SELECT duplicate_offset, duplicate_uom FROM CUG_SR_TYPE_DUP_CHK_INFO
1853: WHERE INCIDENT_TYPE_ID = l_incident_type_id;
1854: l_DuplicateTimeInfo_rec c_DuplicateTimeInfo_csr%ROWTYPE;
1855:
1856: CURSOR c_UOM_Conversion_Rate_csr IS