APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_PERSON_ACTIONS_S

Line 2831: SELECT ben_person_actions_s.NEXTVAL

2827: l_rep_rec(rep_count ).SETUP_VALID := 'Y';
2828: l_rep_rec(rep_count ).TOTAL_PERSONS := 1 ;
2829: l_rep_rec(rep_count ).PERIOD_ID := stmt_rec.period_id;
2830:
2831: SELECT ben_person_actions_s.NEXTVAL
2832: INTO l_person_action_ids (l_num_rows)
2833: FROM DUAL;
2834:
2835: l_person_ids (l_num_rows) := p_person_id;

Line 2987: SELECT ben_person_actions_s.NEXTVAL

2983: l_bg_ids.EXTEND (1);
2984:
2985: hr_utility.set_location ('Adding the person id :' ||per_rec.person_id ,177);
2986:
2987: SELECT ben_person_actions_s.NEXTVAL
2988: INTO l_person_action_ids (l_num_rows)
2989: FROM DUAL;
2990:
2991: l_person_ids (l_num_rows) := per_rec.person_id;

Line 3133: SELECT ben_person_actions_s.NEXTVAL

3129: l_bg_ids.EXTEND (1);
3130:
3131: hr_utility.set_location ('Adding the person id :' ||per_rec.person_id ,184);
3132:
3133: SELECT ben_person_actions_s.NEXTVAL
3134: INTO l_person_action_ids (l_num_rows)
3135: FROM DUAL;
3136:
3137: l_person_ids (l_num_rows) := per_rec.person_id;

Line 3267: SELECT ben_person_actions_s.NEXTVAL

3263: l_stmt_ids.EXTEND (1);
3264: l_perd_ids.EXTEND (1);
3265: l_bg_ids.EXTEND (1);
3266:
3267: SELECT ben_person_actions_s.NEXTVAL
3268: INTO l_person_action_ids (l_num_rows)
3269: FROM DUAL;
3270:
3271: l_person_ids (l_num_rows) := p_person_id;

Line 3349: SELECT ben_person_actions_s.NEXTVAL

3345: l_perd_ids.EXTEND (1);
3346: l_bg_ids.EXTEND (1);
3347:
3348:
3349: SELECT ben_person_actions_s.NEXTVAL
3350: INTO l_person_action_ids (l_num_rows)
3351: FROM DUAL;
3352:
3353: l_person_ids (l_num_rows) := per_rec.person_id;

Line 3436: SELECT ben_person_actions_s.NEXTVAL

3432:
3433: hr_utility.set_location ('Adding the person id :' ||per_rec.person_id ,193);
3434:
3435:
3436: SELECT ben_person_actions_s.NEXTVAL
3437: INTO l_person_action_ids (l_num_rows)
3438: FROM DUAL;
3439:
3440: l_person_ids (l_num_rows) := per_rec.person_id;