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 1898: from ben_person_actions

1894: l_bft_id number;
1895: --
1896: cursor c_ler is
1897: select ler_id
1898: from ben_person_actions
1899: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
1900: --
1901: begin
1902: --

Line 2126: from ben_person_actions ben

2122: -- local variables.
2123: --
2124: cursor c_person_thread is
2125: select ben.object_version_number, ben.person_action_id
2126: from ben_person_actions ben
2127: where ben.benefit_action_id = g_benefit_action_id
2128: and ben.person_id = p_person_id
2129: and ben.action_status_cd <> 'P';
2130: --

Line 2216: from ben_person_actions

2212: l_bft_id number;
2213: --
2214: cursor c_ler is
2215: select ler_id
2216: from ben_person_actions
2217: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
2218: --
2219: begin
2220: --