APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_PERSON_ACTIONS

Line 3044: from ben_person_actions bpa

3040: ,c_ext_rslt_id IN NUMBER)
3041:
3042: IS
3043: select person_action_id
3044: from ben_person_actions bpa
3045: Where bpa.benefit_action_id = c_benefit_action_id
3046: and EXISTS
3047: ( SELECT ers.PERSON_ID
3048: FROM BEN_EXT_RSLT_ERR ers

Line 3068: Update ben_person_actions bpa

3064:
3065: debug('l_ben_params.benefit_action_id :' || l_ben_params.benefit_action_id);
3066:
3067:
3068: Update ben_person_actions bpa
3069: Set bpa.action_status_cd = 'U'
3070: Where bpa.benefit_action_id = l_ben_params.benefit_action_id -- 3629 -- p_benefit_action_id
3071: and bpa.person_id -- = p_person_id;
3072: IN ( SELECT PERSON_ID

Line 3082: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere

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)
3082: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere
3083: Where bpa.benefit_action_id = l_ben_params.benefit_action_id
3084: AND bbr.benefit_action_id = bpa.benefit_action_id
3085: AND (bpa.person_action_id Between
3086: bbr.starting_person_action_id And bbr.ending_person_action_id)

Line 3184: Update ben_person_actions bpa

3180:
3181:
3182: -- (2) update using FORALL and bulk collect all person_action_id
3183: FORALL i in 1..l_person_collection.COUNT
3184: Update ben_person_actions bpa
3185: Set bpa.action_status_cd = 'U'
3186: Where bpa.benefit_action_id = l_ben_params.benefit_action_id
3187: and bpa.person_id = l_person_collection(i)
3188: RETURNING person_action_id BULK COLLECT INTO l_per_action_id_collection;