APPS.HR_US_GARN_GEN dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 2546: UPDATE pay_status_processing_rules_f

2542: ELSE
2543:
2544: -- Make sure to update the "standard" processing rule, ie. which
2545: -- is the one that was checked for in spr_exists.
2546: UPDATE pay_status_processing_rules_f
2547: SET formula_id = v_calc_formula_id
2548: WHERE status_processing_rule_id = already_exists
2549: AND g_eff_start_date between effective_start_date
2550: and effective_end_date;

Line 5025: FROM pay_status_processing_rules_f spr, ff_formulas_f ff

5021:
5022:
5023: CURSOR get_formulae(l_ele_id in number) IS
5024: SELECT distinct ff.formula_id
5025: FROM pay_status_processing_rules_f spr, ff_formulas_f ff
5026: WHERE spr.element_type_id = l_ele_id
5027: AND ff.formula_id = spr.formula_id
5028: AND ff.business_group_id + 0 = p_business_group_id
5029: AND ff.legislation_code IS NULL;

Line 5039: FROM pay_status_processing_rules_f

5035: AND ff.business_group_id + 0 = p_business_group_id;
5036:
5037: CURSOR get_spr(l_ele_id in number) IS
5038: SELECT distinct status_processing_rule_id
5039: FROM pay_status_processing_rules_f
5040: WHERE element_type_id = l_ele_id;
5041:
5042: CURSOR get_freqrule IS
5043: SELECT ele_payroll_freq_rule_id