[Home] [Help]
187: hr_utility.set_location(c_proc, 50);
188: --
189: select COUNT(1)
190: into l_count
191: from pay_payroll_actions ppa,
192: pay_assignment_actions paa
193: where ppa.request_id = l_request_id
194: and ppa.action_type = 'X'
195: and paa.payroll_action_id = ppa.payroll_action_id