DBA Data[Home] [Help]

APPS.PYNEGNET01 dependencies on PAY_FORMULA_RESULT_RULES_F

Line 1699: DELETE FROM pay_formula_result_rules_f

1695: IF ln_id > 0 THEN
1696:
1697: DELETE FROM pay_status_processing_rules_f
1698: WHERE element_type_id = ln_id;
1699: DELETE FROM pay_formula_result_rules_f
1700: WHERE status_processing_rule_id = l_rule_id;
1701: END IF;
1702: else
1703: if ln_id > 0 THEN

Line 1704: DELETE FROM pay_formula_result_rules_f

1700: WHERE status_processing_rule_id = l_rule_id;
1701: END IF;
1702: else
1703: if ln_id > 0 THEN
1704: DELETE FROM pay_formula_result_rules_f
1705: WHERE status_processing_rule_id = l_rule_id;
1706: end if;
1707: end if;
1708: el_cnt := el_cnt + 1;

Line 1939: DELETE FROM pay_formula_result_rules_f

1935: IF ln_vertex_id > 0 THEN
1936: FOR first_rec IN first_inp('SUI_EE_POST_VERTEX')
1937: LOOP
1938: ln_id := first_rec.input_value_id;
1939: DELETE FROM pay_formula_result_rules_f
1940: WHERE
1941: input_value_id = ln_id
1942: ;
1943: -- sd1 element_type_id = ln_vertex_id