APPS.BEN_CWB_POST_PROCESS dependencies on BEN_PERSON_ACTIONS

Line 586: FROM ben_person_actions ben

582: , ben.person_action_id
583: , ben.object_version_number
584: , ben.ler_id
585: , ben.non_person_cd
586: FROM ben_person_actions ben
587: WHERE ben.benefit_action_id = v_benefit_action_id
588: AND ben.action_status_cd <> 'P'
589: AND ben.person_action_id BETWEEN v_start_person_action_id AND v_end_person_action_id
590: ORDER BY ben.person_action_id;

Line 972: FROM ben_person_actions act

968: CURSOR c_actions (v_benefit_action_id IN NUMBER)
969: IS
970: SELECT COUNT (*) amount
971: , action_status_cd
972: FROM ben_person_actions act
973: WHERE act.benefit_action_id = v_benefit_action_id
974: AND act.action_status_cd IN ('P', 'E', 'U')
975: GROUP BY action_status_cd;
976:

Line 1580: INSERT INTO ben_person_actions

1576: g_proc := 'insert_person_actions';
1577: write('Time before inserting person actions '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1578: FORALL l_count IN 1 .. p_per_actn_id_array.COUNT
1579: --
1580: INSERT INTO ben_person_actions
1581: (person_action_id
1582: , person_id
1583: , ler_id
1584: , benefit_action_id

Line 4687: ben_person_actions_api.update_person_actions

4683: write_h ('||Person Action id ' || p_person_action_id);
4684: write_h ('||p_object_version_number ' || p_object_version_number);
4685: write_h ('||p_effective_date ' || p_effective_date);
4686: write_h ('================================================================');
4687: ben_person_actions_api.update_person_actions
4688: (p_person_action_id => p_person_action_id
4689: , p_action_status_cd => 'P'
4690: , p_object_version_number => p_object_version_number
4691: , p_effective_date => p_effective_date

Line 4721: ben_person_actions_api.update_person_actions

4717: ben_batch_utils.rpt_error (p_proc => g_proc, p_last_actn => g_actn, p_rpt_flag => TRUE);
4718:
4719: IF p_person_action_id IS NOT NULL
4720: THEN
4721: ben_person_actions_api.update_person_actions
4722: (p_person_action_id => p_person_action_id
4723: , p_action_status_cd => 'E'
4724: , p_object_version_number => p_object_version_number
4725: , p_effective_date => p_effective_date

Line 5227: SELECT ben_person_actions_s.NEXTVAL

5223: l_person_ids.EXTEND (1);
5224: l_per_in_ler_ids.EXTEND (1);
5225: l_is_placeholder.EXTEND (1);
5226:
5227: SELECT ben_person_actions_s.NEXTVAL
5228: INTO l_person_action_ids (l_num_rows)
5229: FROM DUAL;
5230:
5231: l_person_ids (l_num_rows) := pl_rec.person_id;

Line 5323: SELECT ben_person_actions_s.NEXTVAL

5319: l_per_in_ler_ids.EXTEND (1);
5320: l_is_placeholder.EXTEND (1);
5321:
5322:
5323: SELECT ben_person_actions_s.NEXTVAL
5324: INTO l_person_action_ids (l_num_rows)
5325: FROM DUAL;
5326:
5327: l_person_ids (l_num_rows) := ps_rec.person_id;