DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 98: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

94: -- +------------------------------------------------------------------------------------------------+
95: PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER)
96: IS
97: c_proc CONSTANT VARCHAR2(61) := c_package || 'INITIALIZATION_CODE';
98: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
99: BEGIN
100: hr_utility.set_location('Entering: ' || c_proc, 10);
101: --
102: if g_payroll_action_id is null or g_payroll_action_id <> p_payroll_action_id then

Line 111: from pay_payroll_actions

107: legislative_parameters
108: into g_business_group_id,
109: g_effective_date,
110: l_legislative_parameters
111: from pay_payroll_actions
112: where payroll_action_id = p_payroll_action_id;
113: --
114: -- "Assignment Set" cannot be implemented because of localization strategy
115: -- at the moment.

Line 153: FROM pay_payroll_actions ppa,

149: initialization_code(p_payroll_action_id);
150: --
151: p_sqlstr :=
152: 'SELECT DISTINCT per.person_id
153: FROM pay_payroll_actions ppa,
154: per_all_people_f per
155: WHERE ppa.payroll_action_id = :payroll_action_id
156: AND per.business_group_id + 0 = ppa.business_group_id
157: ORDER BY per.person_id';