APPS.PAY_US_RULES dependencies on PAY_FORMULA_RESULT_RULES_F

Line 941: vresultname pay_formula_result_rules_f.result_name%TYPE,

937:
938: TYPE tinputvalrec IS RECORD
939: (
940: vname pay_input_values_f.name%TYPE,
941: vresultname pay_formula_result_rules_f.result_name%TYPE,
942: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,
943: vinputvalid pay_input_values_f.input_value_id%TYPE
944: );
945: TYPE tinputvalrectab IS TABLE OF tinputvalrec

Line 942: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,

938: TYPE tinputvalrec IS RECORD
939: (
940: vname pay_input_values_f.name%TYPE,
941: vresultname pay_formula_result_rules_f.result_name%TYPE,
942: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,
943: vinputvalid pay_input_values_f.input_value_id%TYPE
944: );
945: TYPE tinputvalrectab IS TABLE OF tinputvalrec
946: INDEX BY BINARY_INTEGER;

Line 1690: FROM pay_formula_result_rules_f

1686: ) IS
1687: SELECT formula_result_rule_id
1688: , effective_start_date
1689: , object_version_number
1690: FROM pay_formula_result_rules_f
1691: WHERE status_processing_rule_id = p_status_processing_rule_id
1692: AND ((business_group_id = p_business_group_id AND
1693: legislation_code IS NULL) OR
1694: (business_group_id IS NULL AND

Line 1754: hr_utility.TRACE ('pay_formula_result_rules_f does not return any row');

1750: ,p_effective_start_date => l_eff_start_date
1751: ,p_effective_end_date => l_eff_end_date
1752: );
1753: ELSE
1754: hr_utility.TRACE ('pay_formula_result_rules_f does not return any row');
1755: END IF;/*c_for_res_rule%FOUND*/
1756: CLOSE c_for_res_rule;
1757:
1758: pay_status_processing_rule_api.delete_status_process_rule