APPS.BEN_CWB_POST_PROCESS dependencies on BEN_PERSON_ACTIONS

Line 597: FROM ben_person_actions ben

593: , ben.person_action_id
594: , ben.object_version_number
595: , ben.ler_id
596: , ben.non_person_cd
597: FROM ben_person_actions ben
598: WHERE ben.benefit_action_id = v_benefit_action_id
599: AND ben.action_status_cd <> 'P'
600: AND ben.person_action_id BETWEEN v_start_person_action_id AND v_end_person_action_id
601: ORDER BY ben.person_action_id;

Line 985: FROM ben_person_actions act

981: CURSOR c_actions (v_benefit_action_id IN NUMBER)
982: IS
983: SELECT COUNT (*) amount
984: , action_status_cd
985: FROM ben_person_actions act
986: WHERE act.benefit_action_id = v_benefit_action_id
987: AND act.action_status_cd IN ('P', 'E', 'U')
988: GROUP BY action_status_cd;
989:

Line 1600: INSERT INTO ben_person_actions

1596: g_proc := 'insert_person_actions';
1597: write('Time before inserting person actions '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1598: FORALL l_count IN 1 .. p_per_actn_id_array.COUNT
1599: --
1600: INSERT INTO ben_person_actions
1601: (person_action_id
1602: , person_id
1603: , ler_id
1604: , benefit_action_id

Line 4764: ben_person_actions_api.update_person_actions

4760: write_h ('||Person Action id ' || p_person_action_id);
4761: write_h ('||p_object_version_number ' || p_object_version_number);
4762: write_h ('||p_effective_date ' || p_effective_date);
4763: write_h ('================================================================');
4764: ben_person_actions_api.update_person_actions
4765: (p_person_action_id => p_person_action_id
4766: , p_action_status_cd => 'P'
4767: , p_object_version_number => p_object_version_number
4768: , p_effective_date => p_effective_date

Line 4798: ben_person_actions_api.update_person_actions

4794: ben_batch_utils.rpt_error (p_proc => g_proc, p_last_actn => g_actn, p_rpt_flag => TRUE);
4795:
4796: IF p_person_action_id IS NOT NULL
4797: THEN
4798: ben_person_actions_api.update_person_actions
4799: (p_person_action_id => p_person_action_id
4800: , p_action_status_cd => 'E'
4801: , p_object_version_number => p_object_version_number
4802: , p_effective_date => p_effective_date

Line 5304: SELECT ben_person_actions_s.NEXTVAL

5300: l_person_ids.EXTEND (1);
5301: l_per_in_ler_ids.EXTEND (1);
5302: l_is_placeholder.EXTEND (1);
5303:
5304: SELECT ben_person_actions_s.NEXTVAL
5305: INTO l_person_action_ids (l_num_rows)
5306: FROM DUAL;
5307:
5308: l_person_ids (l_num_rows) := pl_rec.person_id;

Line 5400: SELECT ben_person_actions_s.NEXTVAL

5396: l_per_in_ler_ids.EXTEND (1);
5397: l_is_placeholder.EXTEND (1);
5398:
5399:
5400: SELECT ben_person_actions_s.NEXTVAL
5401: INTO l_person_action_ids (l_num_rows)
5402: FROM DUAL;
5403:
5404: l_person_ids (l_num_rows) := ps_rec.person_id;