APPS.BEN_ON_LINE_LF_EVT dependencies on BEN_PERSON_ACTIONS

Line 508: from ben_person_actions

504: l_bft_id number;
505: --
506: cursor c_ler is
507: select ler_id
508: from ben_person_actions
509: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
510: --
511: cursor c_ptnl_ler is
512: select count(*)

Line 1309: from ben_person_actions

1305: l_object_version_number number;
1306: --
1307: cursor c_ler is
1308: select ler_id
1309: from ben_person_actions
1310: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
1311: --
1312: begin
1313: --

Line 1444: from ben_person_actions

1440: l_rec benutils.g_active_life_event;
1441: --
1442: cursor c_ler is
1443: select ler_id
1444: from ben_person_actions
1445: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
1446: --
1447: l_bft_id number;
1448: l_assignment_id number;

Line 1886: from ben_person_actions

1882: l_bft_id number;
1883: --
1884: cursor c_ler is
1885: select ler_id
1886: from ben_person_actions
1887: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
1888: --
1889: begin
1890: --

Line 2114: from ben_person_actions ben

2110: -- local variables.
2111: --
2112: cursor c_person_thread is
2113: select ben.object_version_number, ben.person_action_id
2114: from ben_person_actions ben
2115: where ben.benefit_action_id = g_benefit_action_id
2116: and ben.person_id = p_person_id
2117: and ben.action_status_cd <> 'P';
2118: --

Line 2204: from ben_person_actions

2200: l_bft_id number;
2201: --
2202: cursor c_ler is
2203: select ler_id
2204: from ben_person_actions
2205: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
2206: --
2207: begin
2208: --