APPS.PAY_TEMPLATE_IVS dependencies on PAY_INPUT_VALUES_F

Line 70: PAY_INPUT_VALUES_F

66:
67: The normal template generation code in packages pygenptx.pkb, pyusuidt.pkb,
68: pywatgen.pkb will handle the creation of the following rows for the new
69: input value on deductions templates:
70: PAY_INPUT_VALUES_F
71: PAY_BALANCE_FEEDS_F
72: PAY_FORMULA_RESULT_RULES_F
73: NOTE: These rows can be created at any time, regardless of existing
74: payroll runs on the live account.

Line 650: from pay_input_values_f iv

646: begin
647: --
648: select count(distinct iv.input_value_id)
649: into v_num_input_values
650: from pay_input_values_f iv
651: where iv.element_type_id = p_element_type_id
652: and p_val_start_date between
653: iv.effective_start_date and iv.effective_end_date;
654: --

Line 712: from pay_input_values_f

708: into v_validation_check
709: from sys.dual
710: where exists
711: (select 1
712: from pay_input_values_f
713: where element_type_id = p_element_type_id
714: and input_value_id <> p_input_value_id
715: and upper(p_name) = upper(name));
716: --