APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_PERSON_ACTIONS_S

Line 2862: SELECT ben_person_actions_s.NEXTVAL

2858: l_rep_rec(rep_count ).SETUP_VALID := 'Y';
2859: l_rep_rec(rep_count ).TOTAL_PERSONS := 1 ;
2860: l_rep_rec(rep_count ).PERIOD_ID := stmt_rec.period_id;
2861:
2862: SELECT ben_person_actions_s.NEXTVAL
2863: INTO l_person_action_ids (l_num_rows)
2864: FROM DUAL;
2865:
2866: l_person_ids (l_num_rows) := p_person_id;

Line 3018: SELECT ben_person_actions_s.NEXTVAL

3014: l_bg_ids.EXTEND (1);
3015:
3016: hr_utility.set_location ('Adding the person id :' ||per_rec.person_id ,177);
3017:
3018: SELECT ben_person_actions_s.NEXTVAL
3019: INTO l_person_action_ids (l_num_rows)
3020: FROM DUAL;
3021:
3022: l_person_ids (l_num_rows) := per_rec.person_id;

Line 3164: SELECT ben_person_actions_s.NEXTVAL

3160: l_bg_ids.EXTEND (1);
3161:
3162: hr_utility.set_location ('Adding the person id :' ||per_rec.person_id ,184);
3163:
3164: SELECT ben_person_actions_s.NEXTVAL
3165: INTO l_person_action_ids (l_num_rows)
3166: FROM DUAL;
3167:
3168: l_person_ids (l_num_rows) := per_rec.person_id;

Line 3298: SELECT ben_person_actions_s.NEXTVAL

3294: l_stmt_ids.EXTEND (1);
3295: l_perd_ids.EXTEND (1);
3296: l_bg_ids.EXTEND (1);
3297:
3298: SELECT ben_person_actions_s.NEXTVAL
3299: INTO l_person_action_ids (l_num_rows)
3300: FROM DUAL;
3301:
3302: l_person_ids (l_num_rows) := p_person_id;

Line 3395: SELECT ben_person_actions_s.NEXTVAL

3391: l_perd_ids.EXTEND (1);
3392: l_bg_ids.EXTEND (1);
3393:
3394:
3395: SELECT ben_person_actions_s.NEXTVAL
3396: INTO l_person_action_ids (l_num_rows)
3397: FROM DUAL;
3398:
3399: l_person_ids (l_num_rows) := per_rec.person_id;

Line 3483: SELECT ben_person_actions_s.NEXTVAL

3479:
3480: hr_utility.set_location ('Adding the person id :' ||per_rec.person_id ,193);
3481:
3482:
3483: SELECT ben_person_actions_s.NEXTVAL
3484: INTO l_person_action_ids (l_num_rows)
3485: FROM DUAL;
3486:
3487: l_person_ids (l_num_rows) := per_rec.person_id;