APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_PERSON_ACTIONS

Line 2980: from ben_person_actions bpa

2976: ,c_ext_rslt_id IN NUMBER)
2977:
2978: IS
2979: select person_action_id
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

Line 3004: Update ben_person_actions bpa

3000:
3001: debug('l_ben_params.benefit_action_id :' || l_ben_params.benefit_action_id);
3002:
3003:
3004: Update ben_person_actions bpa
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

Line 3018: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere

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)

Line 3120: Update ben_person_actions bpa

3116:
3117:
3118: -- (2) update using FORALL and bulk collect all person_action_id
3119: FORALL i in 1..l_person_collection.COUNT
3120: Update ben_person_actions bpa
3121: Set bpa.action_status_cd = 'U'
3122: Where bpa.benefit_action_id = l_ben_params.benefit_action_id
3123: and bpa.person_id = l_person_collection(i)
3124: RETURNING person_action_id BULK COLLECT INTO l_per_action_id_collection;