APPS.PAY_SIMULATOR_SS_PKG dependencies on PAY_INPUT_VALUES_F

Line 675: from pay_input_values_f inv,pay_element_types_f pet

671: is
672:
673: cursor csr_table_inp_ids is
674: select pet.element_name||'-'||inv.name,inv.uom,inv.lookup_type,inv.value_set_id,inv.min_value,inv.max_value,pet.input_currency_code
675: from pay_input_values_f inv,pay_element_types_f pet
676: where inv.input_value_id = p_input_value_id
677: and trunc(sysdate) between inv.effective_start_date
678: and inv.effective_end_date
679: and inv.element_type_id = pet.element_type_id

Line 692: l_uom pay_input_values_f.uom%TYPE;

688: and ACTION_CONTEXT_TYPE = 'INPUTSLOV'
689: and ACTION_INFORMATION3 = to_char(p_input_value_id);
690:
691: l_name pay_simulation_information.ACTION_INFORMATION1%type;
692: l_uom pay_input_values_f.uom%TYPE;
693: --
694: l_lookup_type pay_input_values_f.lookup_type%TYPE;
695: l_value_set_id pay_input_values_f.value_set_id%TYPE;
696: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;

Line 694: l_lookup_type pay_input_values_f.lookup_type%TYPE;

690:
691: l_name pay_simulation_information.ACTION_INFORMATION1%type;
692: l_uom pay_input_values_f.uom%TYPE;
693: --
694: l_lookup_type pay_input_values_f.lookup_type%TYPE;
695: l_value_set_id pay_input_values_f.value_set_id%TYPE;
696: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;
697: --
698: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;

Line 695: l_value_set_id pay_input_values_f.value_set_id%TYPE;

691: l_name pay_simulation_information.ACTION_INFORMATION1%type;
692: l_uom pay_input_values_f.uom%TYPE;
693: --
694: l_lookup_type pay_input_values_f.lookup_type%TYPE;
695: l_value_set_id pay_input_values_f.value_set_id%TYPE;
696: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;
697: --
698: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
699: l_element_name pay_element_types_f.element_name%TYPE := null;

Line 716: l_min_value pay_input_values_f.min_value%type;

712:
713:
714:
715: lv_dummy varchar2(100);
716: l_min_value pay_input_values_f.min_value%type;
717: l_max_value pay_input_values_f.max_value%type;
718:
719: --
720: l_proc varchar2(72) := 'validate_input_values';

Line 717: l_max_value pay_input_values_f.max_value%type;

713:
714:
715: lv_dummy varchar2(100);
716: l_min_value pay_input_values_f.min_value%type;
717: l_max_value pay_input_values_f.max_value%type;
718:
719: --
720: l_proc varchar2(72) := 'validate_input_values';
721: --