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
32: ,p_date_to IN date
33: )
34: is
35: Begin
36: hr_utility.set_location('Entering BEN_CHECK_ORGANIZATION.chk_org_role_bnf_upd ',11);
37:
38: hr_utility.set_location('p_date_from '||p_date_from ,11);
39: hr_utility.set_location('p_date_to '||p_date_to,11);
40:
74: close chk_org_bnf_upd;
75: end if;
76: end if;
77: end if;
78: hr_utility.set_location('Leaving ben_check_organization.chk_org_role_bnf_upd ',11);
79: End;
80:
81: procedure chk_org_role_bnf_del
82: (
110: end if;
111: End;
112:
113:
114: END BEN_CHECK_ORGANIZATION;
115: