DBA Data[Home] [Help]

APPS.PAY_ADVANCE_PAY_ELE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 10: return pay_element_entries_f.subpriority%TYPE is

6: --
7: function get_subpriority(p_leg_code in varchar2,
8: p_creator_type in varchar2,
9: p_subpriority in number)
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

Line 18: l_subpriority pay_element_entries_f.subpriority%TYPE;

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;
19: --
20: begin
21: --
22: if (p_creator_type not in ('AE','AD')) then