[Home] [Help]
2980: from ben_person_actions bpa
2981: Where bpa.benefit_action_id = c_benefit_action_id
2982: and EXISTS
2983: ( SELECT ers.PERSON_ID
2984: FROM BEN_EXT_RSLT_ERR ers
2985: WHERE ers.person_id = bpa.person_id
2986: AND ers.EXT_RSLT_ID= c_ext_rslt_id
2987: AND typ_cd = 'E');
2988:
3005: Set bpa.action_status_cd = 'U'
3006: Where bpa.benefit_action_id = l_ben_params.benefit_action_id -- 3629 -- p_benefit_action_id
3007: and bpa.person_id -- = p_person_id;
3008: IN ( SELECT PERSON_ID
3009: FROM BEN_EXT_RSLT_ERR
3010: WHERE EXT_RSLT_ID= Ben_Ext_Thread.g_ext_rslt_id -- 2891 -- c_ext_rslt_id
3011: AND typ_cd = 'E');
3012:
3013: Update ben_batch_ranges bbr
3014: set bbr.range_status_cd = 'E'
3015: Where bbr.benefit_action_id = l_ben_params.benefit_action_id
3016: AND EXISTS(
3017: Select 1 -- distinct(bere.person_id)
3018: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere
3019: Where bpa.benefit_action_id = l_ben_params.benefit_action_id
3020: AND bbr.benefit_action_id = bpa.benefit_action_id
3021: AND (bpa.person_action_id Between
3022: bbr.starting_person_action_id And bbr.ending_person_action_id)
3066: CURSOR csr_err_person_id
3067: (p_ext_rslt_id IN NUMBER)
3068: IS
3069: SELECT distinct(ers.PERSON_ID)
3070: FROM BEN_EXT_RSLT_ERR ers
3071: WHERE ers.EXT_RSLT_ID = p_ext_rslt_id
3072: AND typ_cd = 'E';
3073:
3074: CURSOR csr_range_id
3319: -- RAISE_EXTRACT_WARNING
3320: --
3321: -- "Smart" warning function.
3322: -- When called from the Rule of a extract detail data element
3323: -- it logs a warning in the ben_ext_rslt_err table against
3324: -- the person being processed (or as specified by context of
3325: -- assignment id ). It prefixes all warning messages with a
3326: -- string "Warning raised in data element "||element_name
3327: -- This allows the same Rule to be called from different data