| SQL Id | SQL Text |
|---|
| 0808ay5aghxku |
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "MDLCNUAT"."CLAIMS_CSHOS_PREPAID_VIEW" SELECT c.claims_id, c.provider_id, c.provider_name, c.processed_flag issue_invoice_upon_discharge, c.export40 selfpaid_collection,
c.payor_code, c.corporate_code, o.long_name corp_name, p.long_name||:"SYS_B_000"||c.centre_code||:"SYS_B_001"centre_code , c.employee_name, c.new_ic, c.card_no, c.patient_name, c.coverage_id,
c.primary_diagnosis, d.description diagnosis_description, c.admission_date, c.dischargeable_date, c.claims_status, r.claims_status last_claims_status, r.defercd payment_pending_reason,
c.service_date docrcv_date, c.taxinv_receive_date, c.docsubmit_date close_date, c.currcd_orig, c.due_total_orig, c.amt_discount_orig,
c.due_total,
(CASE
WHEN c.claims_status IN (:"SYS_B_002", :"SYS_B_003") THEN
:"SYS_B_004"
ELSE
c.paid_to_claimant
END) PAID_TO_CLAIMANT,
(CASE
WHEN c.claims_status IN (:"SYS_B_005", :"SYS_B_006") THEN
c.due_total
ELSE
c.paid_by_claimant
END) PAID_BY_CLAIMANT,
c.b4adjust_due_total, c.b4adjust_paid_by_claimant, c.b4adjust_paid_to_claimant,
c.patient_prepaid,
(CASE
WHEN NVL(c.export40, :"SYS_B_007") = :"SYS_B_008" AND c.claims_status IN (:"SYS_B_009", :"SYS_B_010") THEN
:"SYS_B_011"
WHEN NVL(c.export40, :"SYS_B_012") = :"SYS_B_013" THEN
c.paid_to_claimant
ELSE
--((NVL(c.due_total_orig, 0) - NVL(c.amt_discount_orig, 0) - NVL(c.due_total_gsta
mt_orig, 0) - NVL(c.due_total_vatamt_orig, 0)) * c.currrt_orig) - NVL(c.patient_prepaid * c.currrt_orig, 0)
NVL(c.due_total, :"SYS_B_014") - NVL(c.patient_prepaid * c.currrt_orig, :"SYS_B_015")
END) pay_to_provider, provider_payment_due_date, pv_no, cheque_date, prepaid_provider_amount,
(CASE
WHEN c.pv_no IS NULL AND c.provider_payment_due_date IS NOT NULL THEN
c.provider_payment_due_date - TRUNC(SYSDATE)
ELSE
NULL
END) PAYMENT_VAIDITY,
(CASE
WHEN c.provider_payment_due_date IS NULL THEN
:"SYS_B_016"
ELSE
:"SYS_B_017"
END) OVERDUE_UNKNOWN_DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) > :"SYS_B_018" THEN
:"SYS_B_019"
ELSE
:"SYS_B_020"
END) OVERDUE_LT_7DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN :"SYS_B_021" AND :"SYS_B_022" THEN
:"SYS_B_023"
ELSE
:"SYS_B_024"
END) OVERDUE_LE_0DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_025" AND -:"SYS_B_026" THEN
:"SYS_B_027"
ELSE
:"SYS_B_028"
END) OVERDUE_GT_0DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_029" AND -:"SYS_B_030" THEN
:"SYS_B_031"
ELSE
:"SYS_B_032"
END) OVERDUE_GT_7DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_033" AND -:"SYS_B_034" THEN
:"SYS_B_035"
ELSE
:"SYS_B_036"
END) OVERDUE_GT_14DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_037" AND -:"S
YS_B_038" THEN
:"SYS_B_039"
ELSE
:"SYS_B_040"
END) OVERDUE_GT_30DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_041" AND -:"SYS_B_042" THEN
:"SYS_B_043"
ELSE
:"SYS_B_044"
END) OVERDUE_GT_60DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) < -:"SYS_B_045" THEN
:"SYS_B_046"
ELSE
:"SYS_B_047"
END) OVERDUE_GT_90DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) <= :"SYS_B_048" THEN
:"SYS_B_049"
ELSE
:"SYS_B_050"
END) ADMISSION_LE_7DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_051" AND :"SYS_B_052" THEN
:"SYS_B_053"
ELSE
:"SYS_B_054"
END) ADMISSION_LE_14DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_055" AND :"SYS_B_056" THEN
:"SYS_B_057"
ELSE
:"SYS_B_058"
END) ADMISSION_LE_21DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_059" AND :"SYS_B_060" THEN
:"SYS_B_061"
ELSE
:"SYS_B_062"
END) ADMISSION_LE_30AYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_063" AND :"SYS_B_064" THEN
:"SYS_B_065"
ELSE
:"SYS_B_066"
END) ADMISSION_LE_60DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_067" AND :"SYS_B_068" THEN
:"SYS_B_069"
ELSE
:"SYS_B_070"
END) ADMISSION_LE_90DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) > :"SYS_B_071" THEN
:"SYS_B_072"
ELSE
:"SYS_B_073"
END) A
DMISSION_GT_90DAYS,
c.admission_remark,
c.remarks assessment_remark,
c.review_remark,
r.payor_remarks approved_remarks,
r.transaction_date,
c.mrn
FROM claims c, rsvamt_tracking r, corporate o, diagnosis d, payor_centre p
WHERE c.claims_id = r.claims_id
AND c.last_claims_status_date = r.transaction_date
AND c.claims_status IN (:"SYS_B_074", :"SYS_B_075")
AND c.claim_type IN (:"SYS_B_076", :"SYS_B_077")
AND c.service_date IS NOT NULL
--AND c.balance_total != 0
AND c.corporate_code = o.corp_code
AND o.cashless_payment = :"SYS_B_078"
AND c.primary_diagnosis = d.icd_code(+)
AND c.payor_code = p.payor_code(+)
AND c.centre_code = p.centre_code(+)
UNION
SELECT c.claims_id, c.provider_id, c.provider_name, c.processed_flag issue_invoice_upon_discharge, c.export40 selfpaid_collection,
c.payor_code, c.corporate_code, o.long_name corp_name, p.long_name||:"SYS_B_079"||c.centre_code||:"SYS_B_080"centre_code , c.employee_name, c.new_ic, c.card_no, c.patient_name, c.coverage_id,
c.primary_diagnosis, d.description diagnosis_description, c.admission_date, c.dischargeable_date, c.claims_status, r.claims_status last_claims_status, r.defercd payment_pending_reason,
c.service_date docrcv_date, c.taxinv_receive_date, c.docsubmit_date close_date, c.currcd_orig, c.due_total_orig, c.amt_discount_orig,
c.due_total,
(CASE
WHEN c.claims_status IN (:"SYS_B_081", :"SYS_B_082") THEN
:"SYS_B_083"
ELSE
c.paid_to_claimant
END) PAID_TO_CLAIMANT,
(CASE
WHEN c.claims_status IN (:"SYS_B_084", :"SYS_B_085") THEN
c.due_total
ELSE
c.paid_by_claimant
END) PAID_BY_CLAIMANT,
c.b4adjust_due_total, c.b4adjust_paid_by_claimant, c.b4adjust_paid_to_claimant,
c.patient_prepaid,
(CASE
WHEN NVL(c.export40, :"SYS_B_086") = :"SYS_B_087" AND c.claims_status IN (:"SYS_B_088", :"SYS_B_089") THEN
:"SYS_B_090"
WHEN NVL(c.export40, :"SYS_B_091") = :"SYS_B_092" THEN
c.paid_to_claimant
ELSE
--((NVL(c.due_total_orig, 0) - NVL(c.amt_discount_orig, 0) - NVL(c.due_total_gstamt_orig, 0) - NVL(c.due_total_vatamt_orig, 0) * c.currrt_orig)) - NVL(c.patient_prepaid * c.currrt_orig, 0)
NVL(c.due_total, :"SYS_B_093") - NVL(c.patient_prepaid * c.currrt_orig, :"SYS_B_094")
END) pay_to_provider, provider_payment_due_date, pv_no, cheque_date, prepaid_provider_amount,
(CASE
WHEN c.pv_no IS NULL AND c.provider_payment_due_date IS NOT NULL THEN
c.provider_payment_due_date - TRUNC(SYSDATE)
ELSE
NULL
END) PAYMENT_VAIDITY,
(CASE
WHEN c.provider_payment_due_date IS NULL THEN
:"SYS_B_095"
ELSE
:"SYS_B_096"
END) OVERDUE_UNKNOWN_DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) > :"SYS_B_097" THEN
:"SYS_B_098"
ELSE
:"SYS_B_099"
END) OVERDUE_LT_7DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN :"SYS_B_100" AND :"SYS_B_101" THEN
:"SYS_B_102"
ELSE
:"SYS_B_103"
END) OVERDUE_LE_0DAYS,
(
CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_104" AND -:"SYS_B_105" THEN
:"SYS_B_106"
ELSE
:"SYS_B_107"
END) OVERDUE_GT_0DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_108" AND -:"SYS_B_109" THEN
:"SYS_B_110"
ELSE
:"SYS_B_111"
END) OVERDUE_GT_7DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_112" AND -:"SYS_B_113" THEN
:"SYS_B_114"
ELSE
:"SYS_B_115"
END) OVERDUE_GT_14DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_116" AND -:"SYS_B_117" THEN
:"SYS_B_118"
ELSE
:"SYS_B_119"
END) OVERDUE_GT_30DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -:"SYS_B_120" AND -:"SYS_B_121" THEN
:"SYS_B_122"
ELSE
:"SYS_B_123"
END) OVERDUE_GT_60DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) < -:"SYS_B_124" THEN
:"SYS_B_125"
ELSE
:"SYS_B_126"
END) OVERDUE_GT_90DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) <= :"SYS_B_127" THEN
:"SYS_B_128"
ELSE
:"SYS_B_129"
END) ADMISSION_LE_7DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_130" AND :"SYS_B_131" THEN
:"SYS_B_132"
ELSE
:"SYS_B_133"
END) ADMISSION_LE_14DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_134" AND :"SYS_B_135" THEN
:"SYS_B_136"
ELSE
:"SYS_B_137"
END) ADMISSION_LE_21DAYS,
(CASE
WHEN TRUNC(SYSDATE
) - TRUNC(c.admission_date) BETWEEN :"SYS_B_138" AND :"SYS_B_139" THEN
:"SYS_B_140"
ELSE
:"SYS_B_141"
END) ADMISSION_LE_30AYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_142" AND :"SYS_B_143" THEN
:"SYS_B_144"
ELSE
:"SYS_B_145"
END) ADMISSION_LE_60DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN :"SYS_B_146" AND :"SYS_B_147" THEN
:"SYS_B_148"
ELSE
:"SYS_B_149"
END) ADMISSION_LE_90DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) > :"SYS_B_150" THEN
:"SYS_B_151"
ELSE
:"SYS_B_152"
END) ADMISSION_GT_90DAYS,
c.admission_remark,
c.remarks assessment_remark,
c.review_remark,
r.payor_remarks approved_remarks,
r.transaction_date,
c.mrn
FROM claims_action a, claims c, rsvamt_tracking r, corporate o, diagnosis d, payor_centre p
WHERE a.claims_status = :"SYS_B_153"
AND a.reason_code IN (:"SYS_B_154", :"SYS_B_155", :"SYS_B_156", :"SYS_B_157", :"SYS_B_158", :"SYS_B_159")
AND a.claims_id = c.claims_id
AND c.claims_id = r.claims_id
AND c.last_claims_status_date = r.transaction_date
AND c.claims_status IN (:"SYS_B_160", :"SYS_B_161")
AND c.claim_type IN (:"SYS_B_162", :"SYS_B_163")
--AND c.balance_total != 0
AND c.corporate_code = o.corp_code
AND o.cashless_payment = :"SYS_B_164"
AND c.primary_diagnosis = d.icd_code(+)
AND c.payor_code = p.payor_code(+)
AND c.centre_code = p.centre_code(+)
|
| 089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL |
| 08bqjmf8490s2 | SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
| 0agc8gu13raqj | SELECT oldest FROM sys.snap_loadertime$ WHERE tableobj# = :1 FOR UPDATE |
| 0d5wunu823w27 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"MDLCNUAT"."PROVIDER_REF_MVIEW"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 0dwc8cwm0br39 | delete from "MDLCNUAT"."CLAIMS_CSHOS_PREPAID_VIEW" |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 1fqj02zpj39bj | delete from "MDLCNUAT"."CLAIMS_SELFPAIDOS_VIEW11" |
| 1td1447bf49r4 | SELECT CRQNO,
RECMODE,
PAYORMEMID,
NAME,
INVNO,
PAYORREFNO,
NRIC,
DOB,
RESTCTRY,
SERVLST,
RECTYP,
POLICYNO,
P.PAYOR_CODE,
(select distinct pc.long_name
from payor_centre pc
where pc.centre_code in
(select co.centre_code
from corporate co
where (co.corp_code = E.Corpcd
or co.PAYOR_CORP_CODE = E.Corpcd) and p.corp_code=co.corp_code and p.corp_code=co.payor_corp_code and g.payor_code=co.payor_code)
) long_name
FROM EST_CRQ E, PLANMAST P, PAYOR_GROUP G
WHERE E.PLANCD = P.PLAN_CODE(+)
AND E.CORPCD = P.CORP_CODE(+)
AND P.PAYOR_CODE = G.PAYOR_CODE(+)
AND P.GROUP_NAME = G.GROUP_CODE(+)
|
| 26zrxtkz00b4c | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"MDLCNUAT"."CLAIMS_CSHOS_PREPAID_VIEW"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 32tsd77ftsm8a |
SELECT C.CLAIMS_ID, TERMINAL_ID, PROVIDER_ID, PATIENT_NAME, CLAIMS_REC_DATE, PAID_TO_CLAIMANT, DUE_TOTAL, SUBSIDIARY_CODE, C.PAYOR_CODE, C.CARD_NO, C.CLAIMS_STATUS, CLAIMS_PROCESS_STATUS, C.CHEQUE_DATE, C.ADMISSION_DATE, C.LAST_TRANSACTION_DATE, C.LAST_TRANSACTION_STATUS, C.CENTRE_CODE, R.LONG_NAME CORPORATE_NAME, E.PAYOR_MEMBER_ID PATIENT_PAYOR_MEMBER_ID, C.POLICY_NO, TRIM(C.PROVIDER_NAME)||:"SYS_B_00"||TRIM(C.PROVIDER_ID)||:"SYS_B_01" PROVIDER_NAME, C.EMPLOYEE_NAME, CM.DESCRIPTION COVERAGE_DESCRIPTION, H.PAYOR_REMARKS APPROVED_REMARKS, D.DESCRIPTION DIAGNOSIS_DESCRIPTION, C.B4ADJUST_DUE_TOTAL, C.B4ADJUST_PAID_BY_CLAIMANT, C.B4ADJUST_PAID_TO_CLAIMANT, C.REMARKS ASSESSMENT_REMARK, H.DEFERCD, (CASE WHEN C.CLAIM_TYPE IN (:"SYS_B_02", :"SYS_B_03") AND C.CLAIMS_REC_DATE < TO_DATE(:"SYS_B_04", :"SYS_B_05") THEN C.PAID_BY_CLAIMANT + NVL(C.DUE_TOTAL_GSTAMT_ORIG, :"SYS_B_06") - NVL(C.GSTAMT_ORIG, :"SYS_B_07") + NVL(C.DUE_TOTAL_VATAMT_ORIG, :"SYS_B_08") - NVL(C.VATAMT_ORIG, :"SYS_B_09") ELSE C.PAID_BY_CLAIMANT END) PAID_BY_CLAIMANT, (CASE WHEN C.CLAIM_TYPE IN (:"SYS_B_10", :"SYS_B_11", :"SYS_B_12") THEN C.CLAIMS_REC_DATE ELSE C.DOCSUBMIT_DATE END) CLAIM_CLOSE_DATE, C.DOCSUBMIT_DATE AS CLOSEDATE, C.SERVICE_DATE , (SELECT DEFERCD ||:"SYS_B_13"|| TO_CHAR(R.TRANSACTION_DATE, :"SYS_B_14") ||:"SYS_B_15"|| S.SDESC1 FROM RSVAMT_TRACKING R , SYC_REFCD S WHERE R.TRANSACTION_DATE= (SELECT MAX(TRANSACTION_DATE) FROM RSVAMT_TRACKING WHERE CLAIMS_ID=
C.CLAIMS_ID AND CLAIMS_STATUS=:"SYS_B_16") AND CLAIMS_ID=C.CLAIMS_ID AND REFGRP=:"SYS_B_17" AND S.REFCD=R.DEFERCD) PAYMENT_PENDING_REASON_TO , (SELECT FDESC2 || :"SYS_B_18"||REFCD|| :"SYS_B_19" LAST_PAYMENT_PENDING_REASON FROM SYC_REFCD WHERE REFGRP =:"SYS_B_20" AND REFCD = (SELECT DEFERCD FROM RSVAMT_TRACKING WHERE CLAIMS_ID = C.CLAIMS_ID AND CLAIMS_STATUS = :"SYS_B_21" AND TRANSACTION_DATE = (SELECT MAX(TRANSACTION_DATE) TRANSACTION_DATE FROM RSVAMT_TRACKING WHERE CLAIMS_ID = C.CLAIMS_ID AND CLAIMS_STATUS = :"SYS_B_22"))) PAYMENT_PENDING_REASON, (SELECT MAX(TRANSACTION_DATE) FROM RSVAMT_TRACKING WHERE CLAIMS_ID=C.CLAIMS_ID AND CLAIMS_STATUS = :"SYS_B_23" ) TRANSACTION_DATE FROM CLAIMS C, CORPORATE R, EMPLOYEE E, DIAGNOSIS D, COVERAGE_MASTER CM, RSVAMT_TRACKING H WHERE C.CLAIM_TYPE IN (:"SYS_B_24", :"SYS_B_25") AND (C.CLAIMS_STATUS IN (:"SYS_B_26") OR (C.CLAIMS_STATUS =:"SYS_B_27" AND C.DUE_TOTAL > :"SYS_B_28")) AND C.SERVICE_DATE IS NULL AND C.CLAIMS_PROCESS_STATUS IS NULL AND C.CORPORATE_CODE = R.CORP_CODE AND C.MEMBER_CONTROL_NO = E.MEMBER_CONTROL_NO AND C.PRIMARY_DIAGNOSIS = D.ICD_CODE(+) AND C.COVERAGE_ID = CM.COVERAGE_CODE AND C.CLAIMS_ID = H.CLAIMS_ID(+) AND C.LAST_TRANSACTION_DATE = H.TRANSACTION_DATE(+) AND C.PAYOR_CODE IN (SELECT RPAD(STNCD, :"SYS_B_29", :"SYS_B_30") FROM SYM_USRSTN WHERE USRID =:"SYS_B_31" AND STNTYP=:"SYS_B_32") ORDER BY C.CLAIMS_ID
|
| 350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
| 3972rvxu3knn3 | delete from sdo_geor_ddl__table$$ |
| 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values) |
| 3c0wwaqss6rbz | SELECT ROLEID, OBJID, INSBY, INSDT FROM SYC_ROLEOBJ WHERE OBJID IN (:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4") UNION SELECT A.ROLEID, A.OBJID, A.INSBY, A.INSDT FROM SYC_ROLEOBJ A, SYC_OBJ B WHERE A.OBJID = B.OBJID AND B.XREFOBJID IN (:"SYS_B_5", :"SYS_B_6", :"SYS_B_7", :"SYS_B_8", :"SYS_B_9") |
| 3f24whg0wsv0n | /* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select sid from v$mystat where rownum=:"SYS_B_0") |
| 4rx5027vvc1wy |
SELECT CRQNO,
RECMODE,
PAYORMEMID,
NAME,
PLANSTARTDT,
PLANENDDT,
TERMINATEDT,
SERVMTH,
SERVFEE,
CARDFEE,
INVNO,
PAYORREFNO,
NRIC,
DOB,
RESTCTRY,
SERVLST,
RECTYP,
POLICYNO,
PROCDT,
EMBOSSDT,
ERRMSG,
PAYORCD,
INSBY,
INSDT,
UPDBY,
UPDDT,
CORPCD,
PAYORPMEMID,
AGENTCD,
AGENCYCD,
AGENCYTEAM,
AGENCYLOC,
BROKERCD,
DEPARTMENT,
BRANCH,
LANG,
RACE,
MARSTS,
RELATIONSHIP,
GROSSPREMIUM,
AGENTCOMM,
MGMTFEE,
MCOFEE,
MNRBRISK,
EXCLUSION,
ADDR1,
ADDR2,
ADDR3,
ADDR4,
e.CITY,
e.STATE,
POSTCD,
RESTELNO,
OFFTELNO,
HPNO,
PASSPORTNO,
PASSPORTCTRY,
GENDER,
PLANCD,
EMPLOYSTS,
PREMIUMPAID,
PREMIUMPAIDDT,
PREMIUMFREQ,
MEMBERENDORSE,
POCDDT,
POLICYENDORSE,
PAYORACCTYP,
POLICYSTARTDT,
POLICYENDDT,
POLICYINFORCE,
POLICYSUSPEND,
CARDACTIVEDT,
CARDNO,
EMPID,
DEPID,
WARNMSG,
PROCBY,
PAYORSEQNO,
EMBOSSREFNO,
EMBOSSBY,
CARDRCVBY,
CARDRCVDT,
CARDDLVBY,
CARDDLVD
T,
POLICYOWNER,
CARDISSUE,
AGENTUNIT,
ENGNM,
CARDTYP,
DESIGNATION,
UNIT,
PLANMASTENDDT,
PLANMASTSTARTDT,
PREFERNM,
REINSTATEMENTDT,
MASTERPOLICYNO,
IDTYP,
PED,
POLICYOWNERIDTYP,
POLICYOWNERIDNO,
POLICYOWNERADDR,
POLICYOWNERRESTELNO,
POLICYOWNEROFFTELNO,
POLICYOWNERHPNO,
SMOKER,
THIRDPARTYPOLICY,
POLICYENDORSECD,
POLICYORIGINCD,
POLICYSTSCHGDT,
POLICYISSDT,
CLIENTID,
POLICYOWNERCLIENTID,
TAKEOVERDT,
MEMBERSTS,
SUBSIDIARY,
MEMBERCLS,
BIZSRC,
PREMIUMMODE,
e.EMAIL,
PREMIUMGRACEDT,
MEMID,
BANKCD,
BANKNM,
BANKACCNO,
BANKACCNM,
PLANDESC,
RESTCTRYDESC,
BANKBRHCD,
COSTCENTER,
PANELPROV,
PLANCOND,
OCCUPATION,
LEGALENTITY,
OFFICECD,
DIVISION,
SUBDEPARTMENT,
EMPLOYLOC,
EMPLOYRGN,
EMPLOYCATG,
MEMCTLNO,
OLDCARDNO,
GROUP_NAME,
SERVICE_LIST,
-- co.REMARKS,
P.REMARKS,
P.SERVICE_LIST,
TRIM(G.DESCRIPTION) || :"SYS_B_0" || G.GROUP_CODE || :"SYS_B_1" AS GROUP_NAME,
PC.LONG_NAME
FROM EST_CRQ E
right join PLANMAST P
on e.plancd = p.plan_code
right join PAYOR_GROUP G
on e.corpcd = p.c
orp_code
inner join PAYOR_CENTRE PC
on pc.payor_code = e.payorcd
inner join CORPORATE CO
on co.centre_code = pc.centre_code
--FROM EST_CRQ E, PLANMAST P, PAYOR_GROUP G
WHERE
--E.PLANCD = P.PLAN_CODE(+)
-- AND E.CORPCD = P.CORP_CODE(+)
P.PAYOR_CODE = G.PAYOR_CODE
AND P.GROUP_NAME = G.GROUP_CODE
AND PC.CENTRE_CODE = CO.CENTRE_CODE
AND (CO.CORP_CODE = E.CORPCD and CO.PAYOR_CORP_CODE = E.CORPCD)
|
| 691naha0u4fpt | /* OracleOEM */
SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/:"SYS_B_0" KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q
WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE=:"SYS_B_1"
AND Q.DESTINATION LIKE :"SYS_B_2"||P.DESTINATION_DBLINK||:"SYS_B_3"
|
| 6dujzr0uu004c | SELECT OBJID, INSBY, INSDT, UPDBY, UPDDT, FDESC, SDESC, MODID, OBJSTS, AUTHNM, AUTHDT, OBJTYP, OBJEXT, PARA, XREFOBJID, PAROBJID, ORDSEQ, FDESC1, SDESC1, FDESC2, SDESC2, SEPARATOR, IMAGE, NOTE, LEVELID, FDESC3, SDESC3, FDESC4, SDESC4, FDESC5, SDESC5, FDESC6, SDESC6, TIMER FROM SYC_OBJ WHERE OBJID=:"SYS_B_0" |
| 6fhr09c578v84 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"MDLCNUAT"."CLAIMS_SELFPAIDOS_VIEW11"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 7c0g5t5kkjz18 |
SELECT CRQNO,
RECMODE,
PAYORMEMID,
NAME,
PLANSTARTDT,
PLANENDDT,
TERMINATEDT,
SERVMTH,
SERVFEE,
CARDFEE,
INVNO,
PAYORREFNO,
NRIC,
DOB,
RESTCTRY,
SERVLST,
RECTYP,
POLICYNO,
PROCDT,
EMBOSSDT,
ERRMSG,
PAYORCD,
INSBY,
INSDT,
UPDBY,
UPDDT,
CORPCD,
PAYORPMEMID,
AGENTCD,
AGENCYCD,
AGENCYTEAM,
AGENCYLOC,
BROKERCD,
DEPARTMENT,
BRANCH,
LANG,
RACE,
MARSTS,
RELATIONSHIP,
GROSSPREMIUM,
AGENTCOMM,
MGMTFEE,
MCOFEE,
MNRBRISK,
EXCLUSION,
ADDR1,
ADDR2,
ADDR3,
ADDR4,
CITY,
STATE,
POSTCD,
RESTELNO,
OFFTELNO,
HPNO,
PASSPORTNO,
PASSPORTCTRY,
GENDER,
PLANCD,
EMPLOYSTS,
PREMIUMPAID,
PREMIUMPAIDDT,
PREMIUMFREQ,
MEMBERENDORSE,
POCDDT,
POLICYENDORSE,
PAYORACCTYP,
POLICYSTARTDT,
POLICYENDDT,
POLICYINFORCE,
POLICYSUSPEND,
CARDACTIVEDT,
CARDNO,
EMPID,
DEPID,
WARNMSG,
PROCBY,
PAYORSEQNO,
EMBOSSREFNO,
EMBOSSBY,
CARDRCVBY,
CARDRCVDT,
CARDDLVBY,
CARDDLVDT,
POLICYOWNER,
CARDISSUE,
AGENTUNIT,
ENGNM,
CARDTYP,
DESIGNATION,
UNIT,
PLANMASTENDDT,
PLANMASTSTARTDT,
PREFERNM,
REINSTATEMENTDT,
MASTERPOLICYNO,
IDTYP,
PED,
POLICYOWNERIDTYP,
POLICYOWNERIDNO,
POLICYOWNERADDR,
POLICYOWNERRESTELNO,
POLICYOWNEROFFTELNO,
POLICYOWNERHPNO,
SMOKER,
THIRDPARTYPOLICY,
POLICYENDORSECD,
POLICYORIGINCD,
POLICYSTSCHGDT,
POLICYISSDT,
CLIENTID,
POLICYOWNERCLIENTID,
TAKEOVERDT,
MEMBERSTS,
SUBSIDIARY,
MEMBERCLS,
BIZSRC,
PREMIUMMODE,
EMAIL,
PREMIUMGRACEDT,
MEMID,
BANKCD,
BANKNM,
BANKACCNO,
BANKACCNM,
PLANDESC,
RESTCTRYDESC,
BANKBRHCD,
COSTCENTER,
PANELPROV,
PLANCOND,
OCCUPATION,
LEGALENTITY,
OFFICECD,
DIVISION,
SUBDEPARTMENT,
EMPLOYLOC,
EMPLOYRGN,
EMPLOYCATG,
MEMCTLNO,
OLDCARDNO,
GROUP_NAME,
SERVICE_LIST,
REMARKS,
P.REMARKS,
P.SERVICE_LIST,
TRIM(G.DESCRIPTION) || :"SYS_B_0" || G.GROUP_CODE || :"SYS_B_1" AS GROUP_NAME,
(SELECT PC.Long_Name
FROM PAYOR_CENTRE PC
WHERE PC.CENTRE_CODE IN
(SELECT CO.CENTRE_CODE
F
ROM CORPORATE CO
WHERE (CO.CORP_CODE = E.CORPCD OR
CO.PAYOR_CORP_CODE = E.CORPCD) ) and rownum = :"SYS_B_2" ) LONG_NAME
FROM EST_CRQ E, PLANMAST P, PAYOR_GROUP G
WHERE E.PLANCD = P.PLAN_CODE(+)
AND E.CORPCD = P.CORP_CODE(+)
AND P.PAYOR_CODE = G.PAYOR_CODE(+)
AND P.GROUP_NAME = G.GROUP_CODE(+)
|
| 7gtztzv329wg0 | select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# |
| 7qyd9yvzcbdd3 |
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "MDLCNUAT"."CLAIMS_SELFPAIDOS_VIEW11" SELECT CANCELLATION_DATE,
claims_id,
provider_id,
provider_name,
claim_type,
claims_status,
admission_date,
dischargeable_date,
claims_rec_date,
service_date,
payor_code,
centre_code,
corporate_code,
plan_id,
plan_start_date,
plan_end_date,
policy_no,
new_ic,
patient_name,
primary_diagnosis,
icd_description,
due_total,
patient_prepaid,
approved_by,
paid_to_claimant,
paid_by_claimant,
os_aging,
selfpaid_difference,
selfpaid_by_member,
selfpaid_rcptno,
selfpaid_collectdt,
selfpaid_by_payor,
selfpaid_by_provider,
selfpaid_by_tpa,
selfpaid_balance,
selfpaid_amount,
selfpaid_acknowledge_date,
terminal_id,
subsidiary_code,
card_no,
corporate_name,
patient_payor_member_id,
employee_name,
coverage_description,
diagnosis_description,
b4adjust_due_total,
b4adjust_paid_by_claimant,
b4adjust_paid_to_claimant,
assessment_remark,
claim_close_date,
claims_process_status,
last_transaction_status,
last_transaction_reason,
export40,
self
paid_collection,
email,
tel_mobile,
employee_id,
member_control_no,
action_category,
transaction_date,
public_remark,
private_remarks,
(CASE
WHEN approved_remarks_58 IS NULL THEN approved_remarks_5630
ELSE approved_remarks_58
END)
approved_remarks,
collection_final_decision,
FOLLOWUP_COUNT,
FOLLOWUP_DATE_1ST,
FOLLOWUP_DATE_2ND,
FOLLOWUP_DATE_3RD,
FOLLOWUP_DATE_LAST,
PAYMENT_RECEIVED
FROM CLAIMS_SELFPAID_VIEW
|
| 88gzrbd52263z | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"MDLCNUAT"."CLAIMS_SELFPAIDOS_VIEW"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 8hmw7qwv9wq8m | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN eschkexception; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 8xdhdgx4qd342 | select log, oldest, oldest_pk, oldest_oid, oldest_new, youngest+1/86400, flag, yscn, oldest_seq from sys.mlog$ where mowner = :1 and master = :2 |
| 9s6jy22p0a3jf |
UPDATE CLAIMS SET REFERREDPHYSICIAN=:1, REFERREDPHYSICIANSPECIALTY=:2, REFERREDOPFORMNO=:3, CARD_NO=:4, PAYOR_CODE=:5, PHYSICIAN_ID=:6, AUTHORIZATION_CODE=:7, CLAIM_NO=:8, PROVIDER_ID=:9, PROVIDER_TYPE=:10, DOCTOR_NAME1=:11, DOCTOR_NAME2=:12, DOCTOR_NAME3=:13, PATIENT_NAME=:14, SERVICE_DATE=:15, RECORD_NO=:16, SUB_RECORD_NO=:17, CORPORATE_CODE=:18, SUBSIDIARY_CODE=:19, BRANCH_CODE=:20, PRIMARY_DIAGNOSIS=:21, MC_TAKEN_DAY=:22, CLAIM_TYPE=:23, PLAN_ID=:24, COVERAGE_ID=:25, ADMISSION_DATE=:26, DISCHARGEABLE_DATE=:27, TRANSMISSION_DATE=:28, CLAIMS_REC_DATE=:29, DAYS_IN_HOSPITAL=:30, COVERAGE_DAYS=:31, NON_COVERAGE_DAYS=:32, ADMISSION_TYPE=:33, PATIENT_PREPAID=:34, INS_PREPAID=:35, DUE_TOTAL=:36, PAID_TOTAL=:37, BALANCE_TOTAL=:38, PAID_BY_CLAIMANT=:39, PAID_TO_CLAIMANT=:40, REJECTION_CODE=:41, CLAIMS_STATUS=:42, COMMISSION_FLAG=:43, APPROVAL=:44, APPROVED_BY=:45, REFERRAL=:46, INVOICE_ID=:47, REMARKS=:48, DISABILITY_NO=:49, HOSP_INVOICE_NO=:50, REMARKS50=:51, REMARKS60=:52, REMARKS70=:53, REMARKS80=:54, PROCESSED_FLAG=:55, EXPORT40=:56, EXPORT80=:57, CHEQUE_NO=:58, EXPORT90=:59, CLAIMS_PROCESS_STATUS=:60, CLAIMS_REF_ID=:61, TERMINAL_ID=:62, TERMINAL_TYPE=:63, AVG_LOS=:64, AVG_BILLS=:65, BF_LIMIT=:66, SECONDARY_DIAGNOSIS=:67, CHEQUE_DATE=:68, PROVIDER_NAME=:69, PANEL_PROVIDER=:70, DEDUCTIBLE=:71, DEPARTMENT=:72, EMPLOYEE_NAME=:73, POLICY_NO=:74, NEW_IC=:75, AGENT_CODE=:76, AGENCY_CODE=:77, BROKER_CODE=:78,
AGENT_TEAM=:79, OFFLINE_REASON=:80, DOCRCV_BY=:81, REVIEW_BY=:82, REVIEW_DATE=:83, SYSTRC=:84, DOCSUBMIT_BY=:85, DOCSUBMIT_DATE=:86, CHEQUE_SENDTO=:87, CHEQUE_TYPE=:88, DELIVERY_TYPE=:89, PAYLINK_CODE=:90, PAYMENT_DESCRIPTION=:91, PAYEE_NAME=:92, ADDR1=:93, ADDR2=:94, ADDR3=:95, ADDR4=:96, POSTCODE=:97, COUNTRY=:98, AUTOPAY=:99, DOCRCV_CENTRE=:100, THIRD_DIAGNOSIS=:101, POLICY_YEAR=:102, CPT_CODE1=:103, CPT_CODE2=:104, CPT_CODE3=:105, CPT_CODE4=:106, CPT_CODE5=:107, PAST_DIAGNOSIS1=:108, PAST_DIAGNOSIS1_DUR=:109, PAST_DIAGNOSIS2=:110, PAST_DIAGNOSIS2_DUR=:111, BODY_PART1=:112, BODY_PART2=:113, BODY_PART3=:114, REFERBY_PHYSICIAN=:115, WARNMSG=:116, ERRMSG=:117, AGENT_UNIT=:118, ADVANCE_PAYMENT=:119, AGENT_HPNO=:120, CURRCD=:121, CURRRT=:122, ENGLISH_NAME=:123, EST_LOS=:124, EST_BILLS=:125, SURGICAL_DATE=:126, CURRCD_ORIG=:127, CURRRT_ORIG=:128, DUE_TOTAL_ORIG=:129, BANKACCNO=:130, LIABILITY_AMT=:131, SELFPAID_COLLECTDT=:132, SELFPAID_UPDBY=:133, SELFPAID_UPDDT=:134, SELFPAID_REM=:135, INTERFACE_CLAIM_NO=:136, PATIENT_HPNO=:137, ACCIDENT_DATE=:138, SURGICAL=:139, ACCIDENTAL=:140, EMERGENCY=:141, NOTIFICATION_DATE=:142, DIAGNOSIS_REMARK=:143, CPT_REMARK=:144, CHEQUE_REMARK=:145, REMINDER=:146, COINSRCAP=:147, PRIVATE_REMARK=:148, PREGNANT_MONTH=:149, OUTPATIENT_TREATMENT=:150, ADMISSION_REFERRAL=:151, CLAIMS_RELATED=:152, PAYEE_ICNO=:153, POLICY_STATUS=:154, SMOKER=:155, THIRD_PARTY_POLICY=:156, POLI
CY_ENDORSEMENT=:157, MEMBER_ENDORSEMENT=:158, PV_NO=:159, REJECTION_NOTE=:160, COINSR_BY_CLAIMANT=:161, ORIGIN_CODE=:162, PREMIUM_PAID_DATE=:163, INTERFACE_CLAIM_NO2=:164, POLICY_ENDORSEMENT_CODE=:165, ADMISSION_REMARK=:166, ADMISSION_PRIVATE_REMARK=:167, REVIEW_REMARK=:168, PLAN_START_DATE=:169, PLAN_END_DATE=:170, POLICY_STATUS_CHANGE_DATE=:171, MEMBER_STATUS=:172, POLICY_START_DATE=:173, MNRB_RISK=:174, FOURTH_DIAGNOSIS=:175, FIFTH_DIAGNOSIS=:176, INTERFACE_CLAIM_NO3=:177, CHEQUE_DESPATCH_BY=:178, CHEQUE_DESPATCH_DATE=:179, SCALEDOWNCAP=:180, SCALEDOWN_BY_CLAIMANT=:181, PATIENT_EMAIL=:182, AGENT_EMAIL=:183, PREAUTH_BENEFIT=:184, CENTRE_CODE=:185, SELFPAID_COLLECTAMT=:186, B4ADJUST_DUE_TOTAL_ORIG=:187, B4ADJUST_DUE_TOTAL=:188, B4ADJUST_PAID_TO_CLAIMANT=:189, B4ADJUST_PAID_BY_CLAIMANT=:190, AMT_SETTLE_BY_PAYOR=:191, AMT_SETTLE_BY_TPA=:192, AMT_SETTLE_BY_PAYOR_DBNNO=:193, AMT_SETTLE_BY_TPA_DBNNO=:194, SELFPAID_RCPTNO=:195, SELFPAID_CRNNO=:196, HOSP_INVOICE_AMT_ORIG=:197, PREMIUM_GRACE_DATE=:198, MEMBER_PV_NO=:199, MEMBER_CHEQUE_NO=:200, MEMBER_CHEQUE_DATE=:201, HOSP_INVOICE_TYPE=:202, PREAUTH_REQUIRED_TRIGGER=:203, EBANK_BATCHNO=:204, EBANK_DATE=:205, EBANK_RESPONSE=:206, BATCH_NO=:207, BATCH_DATE=:208, CLAIMS_SNO=:209, CLIENT_ID=:210, GSTRT=:211, GSTAMT_ORIG=:212, UNIT=:213, COST_CENTER=:214, SERVICE_FEE=:215, VATRT=:216, VATAMT_ORIG=:217, WHTRT=:218, WHTAMT_ORIG=:219, LAST_TRANSACTION_DATE=:220, DESIGNATION=:22
1, MC_START_DATE=:222, MC_END_DATE=:223, PACKAGE_CODE=:224, PACKAGE_DESC=:225, PACKAGE_FEE=:226, LEGAL_ENTITY=:227, OFFICE_CODE=:228, SUBSIDIARY=:229, DIVISION=:230, SUBDEPARTMENT=:231, EMPLOYMENT_LOCATION=:232, EMPLOYMENT_REGION=:233, EMPLOYMENT_CATEGORY=:234, EMPLOYMENT_DATE=:235, AMT_DISCOUNT_ORIG=:236, AMT_DISCOUNT_MEMBER_ORIG=:237, OCCUPATION=:238, LAST_CLAIMS_STATUS_DATE=:239, SERVICE_FEE_FORMULA=:240, SERVICE_FEE_FORMULA_RATE=:241, SERVICE_FEE_GSTRT=:242, SERVICE_FEE_VATRT=:243, SERVICE_FEE_GSTAMT=:244, SERVICE_FEE_VATAMT=:245, PAYOR_SERVICE_FEE=:246, PAYOR_SERVICE_FEE_GSTRT=:247, PAYOR_SERVICE_FEE_VATRT=:248, PAYOR_SERVICE_FEE_GSTAMT=:249, PAYOR_SERVICE_FEE_VATAMT=:250, PAYOR_SERVICE_FEE_INVOICE_NO=:251, MEMBER_CONTROL_NO=:252, DUE_TOTAL_GSTAMT_ORIG=:253, DUE_TOTAL_VATAMT_ORIG=:254, REFERRAL_PROVIDER_ID=:255, CPF_PREPAID=:256, CURRCD_PAYOR=:257, CURRRT_PAYOR=:258, XBORDER=:259, MERCHANT_CODE=:260, SELFPAID_BY_MEMBER=:261, SELFPAID_BY_PAYOR=:262, SELFPAID_BY_PROVIDER=:263, SELFPAID_BY_TPA=:264, EST_LOS_ICU=:265, USER_CODE=:266, LASTEDIT_DATE=:267, ASSIGNED_CODE=:268, BIRTH_DATE=:269, GENDER=:270, CARDSITEID=:271, PROVSITEID=:272, TAXINV_RECEIVE_DATE=:273, ORIGBILL_DESPATCH_DATE=:274, PREPAID_PROVIDER_AMOUNT=:275, PROVIDER_PAYMENT_DUE_DATE=:276, PROVIDER_CRTCD=:277, CLAIMSLIST_RECEIVE_DATE=:278, LAST_TRANSACTION_STATUS=:279, LAST_TRANSACTION_REASON=:280, INS_PREPAID_CRCD=:281, ADMISSION_REASON=:282, CAUSE_AND
_PATHOLOGY=:283, POSSIBILITY_RELAPSE=:284, UNDERLYING_MEDICAL_COND=:285, PROGNOSIS=:286, DISCHARGE_MEDICATION=:287, FOLLOWUP_INSTRUCTION=:288, OTHER_THERAPEUTIC_PROCEDURE=:289, MRN=:290 WHERE CLAIMS_ID=:291 |
| 9tgj4g8y4rwy8 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| a58h05803zt11 | BEGIN ESUPDCLAIMSTS(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24); END; |
| a6u3yjca29nqc | declare
m_stmt varchar2(512);
begin
m_stmt:='delete from sdo_geor_ddl__table$$';
EXECUTE IMMEDIATE m_stmt;
EXCEPTION
WHEN OTHERS THEN
NULL;
end; |
| ay0gtabyvvxgw |
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "MDLCNUAT"."CLAIMS_SELFPAIDOS_VIEW" SELECT CANCELLATION_DATE,
claims_id,
provider_id,
provider_name,
claim_type,
claims_status,
admission_date,
dischargeable_date,
claims_rec_date,
service_date,
payor_code,
centre_code,
corporate_code,
plan_id,
plan_start_date,
plan_end_date,
policy_no,
new_ic,
patient_name,
primary_diagnosis,
icd_description,
due_total,
patient_prepaid,
approved_by,
paid_to_claimant,
paid_by_claimant,
os_aging,
selfpaid_difference,
selfpaid_by_member,
selfpaid_rcptno,
selfpaid_collectdt,
selfpaid_by_payor,
selfpaid_by_provider,
selfpaid_by_tpa,
selfpaid_balance,
selfpaid_amount,
selfpaid_acknowledge_date,
terminal_id,
subsidiary_code,
card_no,
corporate_name,
patient_payor_member_id,
employee_name,
coverage_description,
diagnosis_description,
b4adjust_due_total,
b4adjust_paid_by_claimant,
b4adjust_paid_to_claimant,
assessment_remark,
claim_close_date,
claims_process_status,
last_transaction_status,
last_transaction_reason,
export40,
selfpa
id_collection,
email,
tel_mobile,
employee_id,
member_control_no,
action_category,
transaction_date,
public_remark,
private_remarks,
(CASE
WHEN approved_remarks_58 IS NULL THEN approved_remarks_5630
ELSE approved_remarks_58
END)
approved_remarks,
collection_final_decision,
FOLLOWUP_COUNT,
FOLLOWUP_DATE_1ST,
FOLLOWUP_DATE_2ND,
FOLLOWUP_DATE_3RD,
FOLLOWUP_DATE_LAST,
PAYMENT_RECEIVED
FROM CLAIMS_SELFPAID_VIEW
|
| bbvbdu6tr3c2g | UPDATE SYT_ACSLOG SET LASTOBJID=:1, LASTACSTM=:2 WHERE ACSID=:3 |
| bw8bpsh6aa5yb | INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "MDLCNUAT"."PROVIDER_REF_MVIEW" SELECT * FROM PROVIDER_REF_VIEW
|
| cjaa80k1hvpc1 | select 1 from sys.cdc_change_tables$ where source_schema_name = :1 and source_table_name = :2 and bitand(mvl_flag, 128)=128 |
| g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
| gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME) |
| guh77szg78v3p | UPDATE sys.snap_logdep$ SET snaptime = :1 WHERE snapid = :2 AND tableobj# = :3 |