eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_TCS_STMT_PROCESS dependencies on DUAL

Line 2833: FROM DUAL;

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;
2836: l_stmt_ids (l_num_rows) := stmt_rec.stmt_id;
2837: l_perd_ids(l_num_rows) := stmt_rec.period_id;

Line 2989: FROM DUAL;

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;
2992: l_stmt_ids (l_num_rows) := stmt_rec.stmt_id;
2993: l_perd_ids(l_num_rows) := stmt_rec.period_id;

Line 3135: FROM DUAL;

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;
3138: l_stmt_ids (l_num_rows) := stmt_record_rec (l_loop_cnt).statement_rec.stmt_id;
3139: l_perd_ids(l_num_rows) := stmt_record_rec (l_loop_cnt).statement_rec.period_id;

Line 3269: FROM DUAL;

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;
3272: l_perd_ids(l_num_rows) := p_period_id;
3273: l_bg_ids(l_num_rows) := l_business_group_id;

Line 3351: FROM DUAL;

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;
3354: l_stmt_ids (l_num_rows) := p_stmt_id;
3355: l_perd_ids(l_num_rows) := p_period_id;

Line 3438: FROM DUAL;

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;
3441: l_stmt_ids (l_num_rows) := stmt_record_rec1 (l_loop_cnt).statement_rec1.stmt_id;
3442: l_perd_ids(l_num_rows) := stmt_record_rec1 (l_loop_cnt).statement_rec1.period_id;