DBA Data[Home] [Help]

APPS.HR_TEMPLATE_EXISTENCE dependencies on PAY_FORMULA_RESULT_RULES_F

Line 136: from pay_formula_result_rules_f frr

132: hr_utility.set_location('hr_template_existence.result_rule_exists',10);
133:
134: select frr.formula_result_rule_id
135: into already_exists
136: from pay_formula_result_rules_f frr
137: where frr.status_processing_rule_id = p_spr_id
138: and frr.result_name = p_frr_name
139: and frr.business_group_id = p_bg_id
140: and nvl(frr.input_value_id, nvl(p_iv_id, 0)) = nvl(p_iv_id, 0)