1: package body PAY_NL_RULES as
2: /* $Header: pynlrule.pkb 120.3.12000000.3 2007/07/26 04:58:45 grchandr noship $ */
3: --
4: g_package varchar2(30) := 'pay_nl_rules';
5:
1: package body PAY_NL_RULES as
2: /* $Header: pynlrule.pkb 120.3.12000000.3 2007/07/26 04:58:45 grchandr noship $ */
3: --
4: g_package varchar2(30) := 'pay_nl_rules';
5:
6: -- +********************************************************************+
7: -- | PUBLIC FUNCTIONS |
8: -- +********************************************************************+
132: p_effective_end_date IN Date,
133: p_process_group_name OUT NOCOPY Varchar2) IS
134:
135: CURSOR csr_asg_process_group IS
136: SELECT DECODE(pay_nl_rules.get_object_group_type
137: ,'EMPLOYER'
138: ,prl_information1
139: ,substr(pap.payroll_name,1,30))
140: FROM per_all_assignments_f paa
207: --RETURN 'PAYROLL' ;
208: --RETURN 'EMPLOYER' ;
209: END get_object_group_type;
210:
211: end PAY_NL_RULES;