DBA Data[Home] [Help]

APPS.HRBALDTM dependencies on PAY_ASSIGNMENT_ACTIONS

Line 38: l_ass_action_id pay_assignment_actions.assignment_action_id%type;

34: p_ass_action_id out number
35: )is
36: l_payroll_id per_assignments_f.payroll_id%type;
37: l_consol_set_id pay_payrolls_f.payroll_id%type;
38: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
39: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
40: begin
41: --
42: -- get the payroll id and the consolidation set id

Line 101: from pay_assignment_actions

97: --
98: hr_utility.set_location ('hrbaldtm.get_bal_ass_action', 5);
99: select assignment_action_id
100: into l_ass_action_id
101: from pay_assignment_actions
102: where payroll_action_id = l_pay_action_id;
103: --
104: hr_utility.trace ('Assignment action id = ' || to_char (l_ass_action_id));
105: p_ass_action_id := l_ass_action_id;