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 1778: FROM ben_person_actions ben

1774: )
1775: IS
1776: SELECT ben.person_id, ben.person_action_id, ben.object_version_number,
1777: ben.chunk_number ,ben.ler_id , ben.non_person_cd
1778: FROM ben_person_actions ben
1779: WHERE ben.benefit_action_id = v_benefit_action_id
1780: AND ben.action_status_cd <> 'P'
1781: AND ben.person_action_id BETWEEN v_start_person_action_id
1782: AND v_end_person_action_id

Line 1801: person_id ben_person_actions.person_id%TYPE,

1797: l_effective_date DATE;
1798: l_loop_cnt NUMBER :=1;
1799:
1800: TYPE g_cache_person_process_object IS RECORD (
1801: person_id ben_person_actions.person_id%TYPE,
1802: person_action_id ben_person_actions.person_action_id%TYPE,
1803: object_version_number ben_person_actions.object_version_number%TYPE,
1804: perd_id ben_person_actions.ler_id%TYPE ,
1805: stmt_id ben_person_actions.chunk_number%TYPE,

Line 1802: person_action_id ben_person_actions.person_action_id%TYPE,

1798: l_loop_cnt NUMBER :=1;
1799:
1800: TYPE g_cache_person_process_object IS RECORD (
1801: person_id ben_person_actions.person_id%TYPE,
1802: person_action_id ben_person_actions.person_action_id%TYPE,
1803: object_version_number ben_person_actions.object_version_number%TYPE,
1804: perd_id ben_person_actions.ler_id%TYPE ,
1805: stmt_id ben_person_actions.chunk_number%TYPE,
1806: bg_id ben_person_actions.non_person_cd%TYPE

Line 1803: object_version_number ben_person_actions.object_version_number%TYPE,

1799:
1800: TYPE g_cache_person_process_object IS RECORD (
1801: person_id ben_person_actions.person_id%TYPE,
1802: person_action_id ben_person_actions.person_action_id%TYPE,
1803: object_version_number ben_person_actions.object_version_number%TYPE,
1804: perd_id ben_person_actions.ler_id%TYPE ,
1805: stmt_id ben_person_actions.chunk_number%TYPE,
1806: bg_id ben_person_actions.non_person_cd%TYPE
1807:

Line 1804: perd_id ben_person_actions.ler_id%TYPE ,

1800: TYPE g_cache_person_process_object IS RECORD (
1801: person_id ben_person_actions.person_id%TYPE,
1802: person_action_id ben_person_actions.person_action_id%TYPE,
1803: object_version_number ben_person_actions.object_version_number%TYPE,
1804: perd_id ben_person_actions.ler_id%TYPE ,
1805: stmt_id ben_person_actions.chunk_number%TYPE,
1806: bg_id ben_person_actions.non_person_cd%TYPE
1807:
1808:

Line 1805: stmt_id ben_person_actions.chunk_number%TYPE,

1801: person_id ben_person_actions.person_id%TYPE,
1802: person_action_id ben_person_actions.person_action_id%TYPE,
1803: object_version_number ben_person_actions.object_version_number%TYPE,
1804: perd_id ben_person_actions.ler_id%TYPE ,
1805: stmt_id ben_person_actions.chunk_number%TYPE,
1806: bg_id ben_person_actions.non_person_cd%TYPE
1807:
1808:
1809: );

Line 1806: bg_id ben_person_actions.non_person_cd%TYPE

1802: person_action_id ben_person_actions.person_action_id%TYPE,
1803: object_version_number ben_person_actions.object_version_number%TYPE,
1804: perd_id ben_person_actions.ler_id%TYPE ,
1805: stmt_id ben_person_actions.chunk_number%TYPE,
1806: bg_id ben_person_actions.non_person_cd%TYPE
1807:
1808:
1809: );
1810:

Line 2055: INSERT INTO ben_person_actions

2051: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
2052:
2053: FORALL l_count IN 1 .. p_per_actn_id_array.COUNT
2054:
2055: INSERT INTO ben_person_actions
2056: (person_action_id,
2057: person_id,
2058: benefit_action_id,
2059: action_status_cd,

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;