APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_BATCH_RANGES

Line 3077: Update ben_batch_ranges bbr

3073: FROM BEN_EXT_RSLT_ERR
3074: WHERE EXT_RSLT_ID= Ben_Ext_Thread.g_ext_rslt_id -- 2891 -- c_ext_rslt_id
3075: AND typ_cd = 'E');
3076:
3077: Update ben_batch_ranges bbr
3078: set bbr.range_status_cd = 'E'
3079: Where bbr.benefit_action_id = l_ben_params.benefit_action_id
3080: AND EXISTS(
3081: Select 1 -- distinct(bere.person_id)

Line 3144: FROM ben_batch_ranges bbr

3140: ,p_benefit_action_id IN NUMBER
3141: )
3142: IS
3143: SELECT bbr.range_id
3144: FROM ben_batch_ranges bbr
3145: WHERE bbr.benefit_action_id = p_benefit_action_id
3146: AND p_person_action_id Between
3147: bbr.starting_person_action_id And bbr.ending_person_action_id;
3148:

Line 3228: Update ben_batch_ranges bbr

3224: ELSE
3225: l_itr :=l_RangeID_collection.NEXT(l_itr);
3226: END IF;
3227:
3228: Update ben_batch_ranges bbr
3229: set bbr.range_status_cd = 'E'
3230: Where bbr.range_id = l_RangeID_collection(l_itr);
3231:
3232: END LOOP;