APPS.BEN_MAINTAIN_BENEFIT_ACTIONS dependencies on BEN_PERSON_ACTIONS

Line 252: from ben_person_actions pac

248: and bft.request_id = fnd_global.conc_request_id;
249: --
250: cursor c_person_actions(p_status_cd varchar2) is
251: select count(*)
252: from ben_person_actions pac
253: where pac.benefit_action_id = p_benefit_action_id
254: and pac.action_status_cd = nvl(p_status_cd,pac.action_status_cd);
255: --
256: begin

Line 375: from ben_person_actions pact

371: select pact.person_id,
372: pact.person_action_id,
373: pact.object_version_number,
374: pact.ler_id
375: from ben_person_actions pact
376: where pact.benefit_action_id = c_bft_id
377: and pact.action_status_cd = 'U'
378: and pact.person_action_id
379: between c_stpact_id and c_endpact_id;