APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_SHADOW_INPUT_VALUES

Line 451: from pay_shadow_input_values

447: and effective_end_date;
448: --
449: cursor csr_shd_ipv (c_shd_elename varchar2) is
450: select input_value_id
451: from pay_shadow_input_values
452: where element_type_id =
453: (Select element_type_id
454: from pay_shadow_element_types
455: where template_id = l_template_id

Line 1237: UPDATE pay_shadow_input_values

1233: IF p_deduction_method = 'PE' THEN
1234: for csr_rec in csr_shd_ipv (p_scheme_prefix||' Savings Deduction')
1235: loop
1236: --update the mandatory flag for the Percentage input value
1237: UPDATE pay_shadow_input_values
1238: SET mandatory_flag = 'Y'
1239: WHERE input_value_id = csr_rec.input_value_id;
1240: end loop;
1241: END IF;