1: PACKAGE BODY BEN_CHECK_ORGANIZATION AS
2: /* $Header: bechkorg.pkb 120.1 2011/02/02 14:23:51 krupani ship $ */
3:
4: cursor chk_org_role_upd(p_organization_id in number, p_date_from in date , p_date_to in date) is
5: select '1' from ben_popl_org_f
6: where organization_id = p_organization_id
7: and ( p_date_from > effective_start_date
8: or nvl(p_date_to, effective_end_date) < effective_end_date);
9:
7: and ( p_date_from > effective_start_date
8: or nvl(p_date_to, effective_end_date) < effective_end_date);
9:
10: cursor chk_org_role_del(p_organization_id in number) is
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