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 BEN_PERSON_ACTIONS

Line 1770: FROM ben_person_actions ben

1766: )
1767: IS
1768: SELECT ben.person_id, ben.person_action_id, ben.object_version_number,
1769: ben.chunk_number ,ben.ler_id , ben.non_person_cd
1770: FROM ben_person_actions ben
1771: WHERE ben.benefit_action_id = v_benefit_action_id
1772: AND ben.action_status_cd <> 'P'
1773: AND ben.person_action_id BETWEEN v_start_person_action_id
1774: AND v_end_person_action_id

Line 1793: person_id ben_person_actions.person_id%TYPE,

1789: l_effective_date DATE;
1790: l_loop_cnt NUMBER :=1;
1791:
1792: TYPE g_cache_person_process_object IS RECORD (
1793: person_id ben_person_actions.person_id%TYPE,
1794: person_action_id ben_person_actions.person_action_id%TYPE,
1795: object_version_number ben_person_actions.object_version_number%TYPE,
1796: perd_id ben_person_actions.ler_id%TYPE ,
1797: stmt_id ben_person_actions.chunk_number%TYPE,

Line 1794: person_action_id ben_person_actions.person_action_id%TYPE,

1790: l_loop_cnt NUMBER :=1;
1791:
1792: TYPE g_cache_person_process_object IS RECORD (
1793: person_id ben_person_actions.person_id%TYPE,
1794: person_action_id ben_person_actions.person_action_id%TYPE,
1795: object_version_number ben_person_actions.object_version_number%TYPE,
1796: perd_id ben_person_actions.ler_id%TYPE ,
1797: stmt_id ben_person_actions.chunk_number%TYPE,
1798: bg_id ben_person_actions.non_person_cd%TYPE

Line 1795: object_version_number ben_person_actions.object_version_number%TYPE,

1791:
1792: TYPE g_cache_person_process_object IS RECORD (
1793: person_id ben_person_actions.person_id%TYPE,
1794: person_action_id ben_person_actions.person_action_id%TYPE,
1795: object_version_number ben_person_actions.object_version_number%TYPE,
1796: perd_id ben_person_actions.ler_id%TYPE ,
1797: stmt_id ben_person_actions.chunk_number%TYPE,
1798: bg_id ben_person_actions.non_person_cd%TYPE
1799:

Line 1796: perd_id ben_person_actions.ler_id%TYPE ,

1792: TYPE g_cache_person_process_object IS RECORD (
1793: person_id ben_person_actions.person_id%TYPE,
1794: person_action_id ben_person_actions.person_action_id%TYPE,
1795: object_version_number ben_person_actions.object_version_number%TYPE,
1796: perd_id ben_person_actions.ler_id%TYPE ,
1797: stmt_id ben_person_actions.chunk_number%TYPE,
1798: bg_id ben_person_actions.non_person_cd%TYPE
1799:
1800:

Line 1797: stmt_id ben_person_actions.chunk_number%TYPE,

1793: person_id ben_person_actions.person_id%TYPE,
1794: person_action_id ben_person_actions.person_action_id%TYPE,
1795: object_version_number ben_person_actions.object_version_number%TYPE,
1796: perd_id ben_person_actions.ler_id%TYPE ,
1797: stmt_id ben_person_actions.chunk_number%TYPE,
1798: bg_id ben_person_actions.non_person_cd%TYPE
1799:
1800:
1801: );

Line 1798: bg_id ben_person_actions.non_person_cd%TYPE

1794: person_action_id ben_person_actions.person_action_id%TYPE,
1795: object_version_number ben_person_actions.object_version_number%TYPE,
1796: perd_id ben_person_actions.ler_id%TYPE ,
1797: stmt_id ben_person_actions.chunk_number%TYPE,
1798: bg_id ben_person_actions.non_person_cd%TYPE
1799:
1800:
1801: );
1802:

Line 2047: INSERT INTO ben_person_actions

2043: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
2044:
2045: FORALL l_count IN 1 .. p_per_actn_id_array.COUNT
2046:
2047: INSERT INTO ben_person_actions
2048: (person_action_id,
2049: person_id,
2050: benefit_action_id,
2051: action_status_cd,

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;