91: ,p_eff_date date)
92: is
93: select paf.assignment_id
94: , paf.business_group_id
95: from pay_temp_object_actions toa
96: , per_all_assignments_f paf
97: where toa.object_action_id = p_ass_act_id
98: and toa.object_type = 'ASG'
99: and toa.object_id = paf.assignment_id
115: select
116: pay_core_utils.get_parameter('FORM_ID', ppa.legislative_parameters)
117: into l_formula_id
118: from pay_payroll_actions ppa
119: , pay_temp_object_actions toa
120: where ppa.payroll_action_id = toa.payroll_action_id
121: and toa.object_action_id = p_assactid;
122: --
123: l_effective_date := p_effective_date;
185: and pbg.business_group_id = ppa.business_group_id;
186: --
187: select count(*)
188: into cnt_incomplete_actions
189: from pay_temp_object_actions
190: where payroll_action_id = pactid
191: and action_status <> 'C';
192: --
193: --