APPS.BEN_CHECK_ORGANIZATION dependencies on BEN_PL_BNF_F

Line 15: select '1' from ben_pl_bnf_f

11: select '1' from ben_popl_org_f
12: where organization_id = p_organization_id;
13:
14: cursor chk_org_bnf_upd(p_organization_id in number, p_date_from in date, p_date_to in date) is
15: select '1' from ben_pl_bnf_f
16: where organization_id = p_organization_id
17: and ( p_date_from > effective_start_date
18: or nvl(p_date_to, effective_end_date) < effective_end_date);
19:

Line 21: select '1' from ben_pl_bnf_f

17: and ( p_date_from > effective_start_date
18: or nvl(p_date_to, effective_end_date) < effective_end_date);
19:
20: cursor chk_org_bnf_del(p_organization_id in number) is
21: select '1' from ben_pl_bnf_f
22: where organization_id = p_organization_id;
23:
24: l_data_exists varchar2(2);
25: l_status varchar2(1);