5307: l_payroll_id
5308: From
5309: pay_element_entry_values_f peev,
5310: pay_element_entries_f pee,
5311: per_pay_bases ppb,
5312: hr_soft_coding_keyflex hscf,
5313: per_assignments_f asg,
5314: hr_lookups hl
5315: Where
5353: 'HOURLY','H',
5354: 'PERIOD','P'
5355: )
5356: into p_frequency
5357: from per_pay_bases ppb ,
5358: per_all_assignments_f paf
5359: where paf.assignment_id = p_assignment_id
5360: and ppb.pay_basis_id = paf.pay_basis_id
5361: and ppb.BUSINESS_GROUP_ID=p_business_group_id ;