APPS.PAY_PAYWSQEE_PKG dependencies on PAY_INPUT_VALUES_F

Line 99: from pay_input_values_f iv,

95: iv.lookup_type,
96: iv.uom,
97: iv.value_set_id
98: --
99: from pay_input_values_f iv,
100: pay_input_values_f_tl ivtl
101: --
102: where p_effective_date between iv.effective_start_date
103: and iv.effective_end_date

Line 100: pay_input_values_f_tl ivtl

96: iv.uom,
97: iv.value_set_id
98: --
99: from pay_input_values_f iv,
100: pay_input_values_f_tl ivtl
101: --
102: where p_effective_date between iv.effective_start_date
103: and iv.effective_end_date
104: and iv.element_type_id = p_element_type_id

Line 399: from pay_input_values_f iv,

395: ivtl.name,
396: iv.lookup_type,
397: iv.uom
398: --
399: from pay_input_values_f iv,
400: pay_input_values_f_tl ivtl
401: --
402: where p_effective_date between iv.effective_start_date
403: and iv.effective_end_date

Line 400: pay_input_values_f_tl ivtl

396: iv.lookup_type,
397: iv.uom
398: --
399: from pay_input_values_f iv,
400: pay_input_values_f_tl ivtl
401: --
402: where p_effective_date between iv.effective_start_date
403: and iv.effective_end_date
404: and iv.element_type_id = p_element_type_id

Line 1235: l_uom_value pay_input_values_f.UOM%TYPE;

1231: l_display_value varchar2(80) := p_input_value;
1232: l_internal_value varchar2(80) := p_input_value;
1233: l_dummy varchar2(100);
1234: --
1235: l_uom_value pay_input_values_f.UOM%TYPE;
1236: l_lookup_type pay_input_values_f.LOOKUP_TYPE%TYPE;
1237: l_value_set_id pay_input_values_f.VALUE_SET_ID%TYPE;
1238: l_currency_code pay_element_types_f.input_currency_code%TYPE;
1239: l_count number;

Line 1236: l_lookup_type pay_input_values_f.LOOKUP_TYPE%TYPE;

1232: l_internal_value varchar2(80) := p_input_value;
1233: l_dummy varchar2(100);
1234: --
1235: l_uom_value pay_input_values_f.UOM%TYPE;
1236: l_lookup_type pay_input_values_f.LOOKUP_TYPE%TYPE;
1237: l_value_set_id pay_input_values_f.VALUE_SET_ID%TYPE;
1238: l_currency_code pay_element_types_f.input_currency_code%TYPE;
1239: l_count number;
1240: l_found number;

Line 1237: l_value_set_id pay_input_values_f.VALUE_SET_ID%TYPE;

1233: l_dummy varchar2(100);
1234: --
1235: l_uom_value pay_input_values_f.UOM%TYPE;
1236: l_lookup_type pay_input_values_f.LOOKUP_TYPE%TYPE;
1237: l_value_set_id pay_input_values_f.VALUE_SET_ID%TYPE;
1238: l_currency_code pay_element_types_f.input_currency_code%TYPE;
1239: l_count number;
1240: l_found number;
1241: --

Line 1255: from pay_input_values_f inv,

1251: select inv.UOM,
1252: inv.LOOKUP_TYPE,
1253: inv.VALUE_SET_ID,
1254: etp.input_currency_code
1255: from pay_input_values_f inv,
1256: pay_element_types_f etp
1257: where inv.element_type_id = p_element_type_id
1258: and etp.element_type_id = p_element_type_id
1259: and p_session_date between inv.effective_start_date