DBA Data[Home] [Help]

APPS.PAY_ADVANCE_PAY_ELE_PKG dependencies on PAY_LEGISLATION_RULES

Line 4: g_leg_code pay_legislation_rules.legislation_code%TYPE := null;

1: PACKAGE BODY PAY_ADVANCE_PAY_ELE_PKG as
2: /* $Header: pyadvele.pkb 115.0 2003/11/13 16:29 susivasu noship $ */
3: --
4: g_leg_code pay_legislation_rules.legislation_code%TYPE := null;
5: g_subpriority number := null;
6: --
7: function get_subpriority(p_leg_code in varchar2,
8: p_creator_type in varchar2,

Line 14: from pay_legislation_rules plr

10: return pay_element_entries_f.subpriority%TYPE is
11: --
12: cursor csr_subpriority is
13: select to_number(plr.rule_mode)
14: from pay_legislation_rules plr
15: where upper(plr.legislation_code) = upper(p_leg_code)
16: and upper(plr.rule_type) = 'ADV_EE_SUBPRIORITY';
17: --
18: l_subpriority pay_element_entries_f.subpriority%TYPE;