83:
84: cursor csr_get_formula_id ( p_id_flex_num number) is
85: select HOI2.org_information1
86: from hr_organization_units HOU
87: ,hr_organization_information HOI1
88: ,hr_organization_information HOI2
89: ,hr_soft_coding_keyflex HSCK
90: ,per_all_assignments_f PAA
91: where HOU.business_group_id = p_business_group_id
84: cursor csr_get_formula_id ( p_id_flex_num number) is
85: select HOI2.org_information1
86: from hr_organization_units HOU
87: ,hr_organization_information HOI1
88: ,hr_organization_information HOI2
89: ,hr_soft_coding_keyflex HSCK
90: ,per_all_assignments_f PAA
91: where HOU.business_group_id = p_business_group_id
92: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,