APPS.HR_US_GARN_GEN dependencies on PAY_FORMULA_RESULT_RULES_F

Line 151: result rules from pay_formula_result_rules_f

147: calculator elements. Added formula result rules
148: of Garn_fee in calculator. Added Diff_dedn_amt
149: and Diff_fee_amt formula result rules to verifier
150: element. Added delete stmt to delete formula
151: result rules from pay_formula_result_rules_f
152: so that no unnecessary result rules are hanging !
153:
154: 04 Dec 1998 ssarma 40.28 774717 Added back dedn at time of writ
155: to the tax levy element.

Line 4257: delete from pay_formula_result_rules_f

4253:
4254: -- Formula Result Rules for BASE ELEMENT
4255: -- ie. garn_statproc_rule_id(1)
4256: hr_utility.set_location('Here', 1);
4257: delete from pay_formula_result_rules_f
4258: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(1);
4259:
4260: hr_utility.set_location('Here', 2);
4261: FOR n in 1..l_num_base_resrules LOOP

Line 4302: delete from pay_formula_result_rules_f

4298:
4299: -- Formula Result Rules for CALCULATION ELEMENT
4300: -- ie. garn_statproc_rule_id(2)
4301: hr_utility.set_location('Here', 7);
4302: delete from pay_formula_result_rules_f
4303: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(2);
4304:
4305: hr_utility.set_location('Here', 8);
4306: FOR o in 1..l_num_calc_resrules LOOP

Line 4349: delete from pay_formula_result_rules_f

4345: -- Formula Result Rules for VERIFIER PRIORITY ELEMENT
4346: -- ie. garn_statproc_rule_id(7)
4347: IF p_category in ('CS', 'SS', 'AY') THEN
4348: hr_utility.set_location('Here', 14);
4349: delete from pay_formula_result_rules_f
4350: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(7);
4351: hr_utility.set_location('Here', 15);
4352:
4353: FOR o in 1..l_num_vp_resrules LOOP

Line 4396: delete from pay_formula_result_rules_f

4392: -- Formula Result Rules for VERIFIER ELEMENT
4393: -- ie. garn_statproc_rule_id(3) , only required for support orders...
4394: IF p_category in ('CS', 'SS', 'AY') THEN
4395: hr_utility.set_location('Here', 21);
4396: delete from pay_formula_result_rules_f
4397: where STATUS_PROCESSING_RULE_ID = garn_statproc_rule_id(3);
4398:
4399: FOR p in 1..l_num_verif_resrules LOOP
4400: