DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PAY_INPUT_VALUES_F

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

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

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

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

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

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

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

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

Line 2941: from pay_input_values_f inv,

2937: inv.uom,
2938: inv.lookup_type,
2939: inv.value_set_id,
2940: etp.input_currency_code
2941: from pay_input_values_f inv,
2942: pay_element_types_f etp
2943: where inv.element_type_id = l_element_type_id
2944: and etp.element_type_id = l_element_type_id
2945: -- and ((inv.business_group_id +0 = l_business_group_id) OR