APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_BATCH_RANGES

Line 3013: Update ben_batch_ranges bbr

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)

Line 3080: FROM ben_batch_ranges bbr

3076: ,p_benefit_action_id IN NUMBER
3077: )
3078: IS
3079: SELECT bbr.range_id
3080: FROM ben_batch_ranges bbr
3081: WHERE bbr.benefit_action_id = p_benefit_action_id
3082: AND p_person_action_id Between
3083: bbr.starting_person_action_id And bbr.ending_person_action_id;
3084:

Line 3164: Update ben_batch_ranges bbr

3160: ELSE
3161: l_itr :=l_RangeID_collection.NEXT(l_itr);
3162: END IF;
3163:
3164: Update ben_batch_ranges bbr
3165: set bbr.range_status_cd = 'E'
3166: Where bbr.range_id = l_RangeID_collection(l_itr);
3167:
3168: END LOOP;