APPS.PAY_US_RULES dependencies on PAY_FORMULA_RESULT_RULES_F

Line 996: vresultname pay_formula_result_rules_f.result_name%TYPE,

992:
993: TYPE tinputvalrec IS RECORD
994: (
995: vname pay_input_values_f.name%TYPE,
996: vresultname pay_formula_result_rules_f.result_name%TYPE,
997: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,
998: vinputvalid pay_input_values_f.input_value_id%TYPE
999: );
1000: TYPE tinputvalrectab IS TABLE OF tinputvalrec

Line 997: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,

993: TYPE tinputvalrec IS RECORD
994: (
995: vname pay_input_values_f.name%TYPE,
996: vresultname pay_formula_result_rules_f.result_name%TYPE,
997: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,
998: vinputvalid pay_input_values_f.input_value_id%TYPE
999: );
1000: TYPE tinputvalrectab IS TABLE OF tinputvalrec
1001: INDEX BY BINARY_INTEGER;

Line 1745: FROM pay_formula_result_rules_f

1741: ) IS
1742: SELECT formula_result_rule_id
1743: , effective_start_date
1744: , object_version_number
1745: FROM pay_formula_result_rules_f
1746: WHERE status_processing_rule_id = p_status_processing_rule_id
1747: AND ((business_group_id = p_business_group_id AND
1748: legislation_code IS NULL) OR
1749: (business_group_id IS NULL AND

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

1805: ,p_effective_start_date => l_eff_start_date
1806: ,p_effective_end_date => l_eff_end_date
1807: );
1808: ELSE
1809: hr_utility.TRACE ('pay_formula_result_rules_f does not return any row');
1810: END IF;/*c_for_res_rule%FOUND*/
1811: CLOSE c_for_res_rule;
1812:
1813: pay_status_processing_rule_api.delete_status_process_rule