DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PAY_INPUT_VALUES_F

Line 2812: l_input_value_id pay_input_values_f.input_value_id%TYPE :=null;

2808: l_assignment_id pay_batch_lines.assignment_id%TYPE :=null;
2809: l_element_name pay_batch_lines.element_name%TYPE :=null;
2810: l_assignment_number pay_batch_lines.assignment_number%TYPE :=null;
2811: l_error_text pay_message_lines.line_text%TYPE :=null;
2812: l_input_value_id pay_input_values_f.input_value_id%TYPE :=null;
2813: l_uom pay_input_values_f.uom%TYPE :=null;
2814: l_input_curr_code pay_element_types_f.input_currency_code%TYPE := null;
2815: l_lookup_type pay_input_values_f.lookup_type%TYPE :=null;
2816: l_value_set_id pay_input_values_f.value_set_id%TYPE :=null;

Line 2813: l_uom pay_input_values_f.uom%TYPE :=null;

2809: l_element_name pay_batch_lines.element_name%TYPE :=null;
2810: l_assignment_number pay_batch_lines.assignment_number%TYPE :=null;
2811: l_error_text pay_message_lines.line_text%TYPE :=null;
2812: l_input_value_id pay_input_values_f.input_value_id%TYPE :=null;
2813: l_uom pay_input_values_f.uom%TYPE :=null;
2814: l_input_curr_code pay_element_types_f.input_currency_code%TYPE := null;
2815: l_lookup_type pay_input_values_f.lookup_type%TYPE :=null;
2816: l_value_set_id pay_input_values_f.value_set_id%TYPE :=null;
2817: l_costable_type pay_element_links_f.costable_type%TYPE :=null;

Line 2815: l_lookup_type pay_input_values_f.lookup_type%TYPE :=null;

2811: l_error_text pay_message_lines.line_text%TYPE :=null;
2812: l_input_value_id pay_input_values_f.input_value_id%TYPE :=null;
2813: l_uom pay_input_values_f.uom%TYPE :=null;
2814: l_input_curr_code pay_element_types_f.input_currency_code%TYPE := null;
2815: l_lookup_type pay_input_values_f.lookup_type%TYPE :=null;
2816: l_value_set_id pay_input_values_f.value_set_id%TYPE :=null;
2817: l_costable_type pay_element_links_f.costable_type%TYPE :=null;
2818: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE:=null;
2819: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE:=null;

Line 2816: l_value_set_id pay_input_values_f.value_set_id%TYPE :=null;

2812: l_input_value_id pay_input_values_f.input_value_id%TYPE :=null;
2813: l_uom pay_input_values_f.uom%TYPE :=null;
2814: l_input_curr_code pay_element_types_f.input_currency_code%TYPE := null;
2815: l_lookup_type pay_input_values_f.lookup_type%TYPE :=null;
2816: l_value_set_id pay_input_values_f.value_set_id%TYPE :=null;
2817: l_costable_type pay_element_links_f.costable_type%TYPE :=null;
2818: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE:=null;
2819: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE:=null;
2820: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE :=null;

Line 2937: from pay_input_values_f inv,

2933: inv.uom,
2934: inv.lookup_type,
2935: inv.value_set_id,
2936: etp.input_currency_code
2937: from pay_input_values_f inv,
2938: pay_element_types_f etp
2939: where inv.element_type_id = l_element_type_id
2940: and etp.element_type_id = l_element_type_id
2941: -- and ((inv.business_group_id +0 = l_business_group_id) OR