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 2864: FROM DUAL;

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

Line 3020: FROM DUAL;

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

Line 3166: FROM DUAL;

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

Line 3300: FROM DUAL;

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

Line 3397: FROM DUAL;

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

Line 3485: FROM DUAL;

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