75: return NUMBER is
76: cursor csr_get_formula_id is
77: select HOI2.org_information1
78: from hr_organization_units HOU
79: ,hr_organization_information HOI1
80: ,hr_organization_information HOI2
81: ,hr_soft_coding_keyflex HSCK
82: ,per_all_assignments_f PAA
83: where HOU.business_group_id = p_business_group_id
76: cursor csr_get_formula_id is
77: select HOI2.org_information1
78: from hr_organization_units HOU
79: ,hr_organization_information HOI1
80: ,hr_organization_information HOI2
81: ,hr_soft_coding_keyflex HSCK
82: ,per_all_assignments_f PAA
83: where HOU.business_group_id = p_business_group_id
84: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,