642: hr_utility.trace('If condition ... count = 0');
643:
644: SELECT formula_type_id
645: INTO l_formula_type_id
646: FROM ff_formula_types
647: WHERE formula_type_name = 'Oracle Payroll';
648:
649: -- SELECT formula_text
650: -- INTO l_formula_text
757: hr_utility.trace('If condition ... count = 0');
758:
759: SELECT formula_type_id
760: INTO l_formula_type_id
761: FROM ff_formula_types
762: WHERE formula_type_name = 'Oracle Payroll';
763:
764: -- SELECT formula_text
765: -- INTO l_formula_text
1098: IF (l_count = 0) THEN
1099: hr_utility.trace('If condition ...creating formula');
1100: SELECT formula_type_id
1101: INTO l_formula_type_id
1102: FROM ff_formula_types
1103: WHERE formula_type_name = 'Oracle Payroll';
1104:
1105: -- SELECT formula_text
1106: -- INTO l_formula_text
1476:
1477: IF (l_count = 0) THEN
1478: SELECT formula_type_id
1479: INTO l_formula_type_id
1480: FROM ff_formula_types
1481: WHERE formula_type_name = 'Oracle Payroll';
1482:
1483: -- SELECT formula_text
1484: -- INTO l_formula_text
2248: IF (l_count = 0) THEN
2249:
2250: SELECT formula_type_id
2251: INTO l_formula_type_id
2252: FROM ff_formula_types
2253: WHERE formula_type_name = 'Oracle Payroll';
2254:
2255: -- SELECT formula_text
2256: -- INTO l_formula_text