APPS.PAY_SIMULATOR_SS_PKG dependencies on PAY_ELEMENT_TYPES_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 696: l_input_curr_code pay_element_types_f.input_currency_code%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;
700: l_count number := 0;

Line 698: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;

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;
700: l_count number := 0;
701: l_legislation_code per_business_groups.legislation_code%TYPE := null;
702: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 699: l_element_name pay_element_types_f.element_name%TYPE := null;

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;
700: l_count number := 0;
701: l_legislation_code per_business_groups.legislation_code%TYPE := null;
702: l_business_group_id per_business_groups.business_group_id%TYPE;
703: l_batch_id pay_batch_lines.batch_id%TYPE;