DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on PAY_INPUT_VALUES_F_TL

Line 109: pay_input_values_f_tl ivtl,

105: iv.uom,
106: TO_NuMBER(REPLACE(fdfcu.application_column_name,'ATTRIBUTE')) otl_sequence,
107: iv.display_sequence
108: from pay_input_values_f iv,
109: pay_input_values_f_tl ivtl,
110: fnd_descr_flex_column_usages fdfcu
111: where p_effective_date between iv.effective_start_date
112: and iv.effective_end_date
113: and iv.element_type_id = p_element_type_id

Line 128: pay_input_values_f_tl ivtl

124: iv.uom,
125: NULL otl_sequence,
126: iv.display_sequence
127: from pay_input_values_f iv,
128: pay_input_values_f_tl ivtl
129: --
130: where p_effective_date between iv.effective_start_date
131: and iv.effective_end_date
132: and iv.element_type_id = p_element_type_id

Line 149: pay_input_values_f_tl ivtl

145: iv.uom,
146: rank() over (partition by iv.element_type_id order by iv.display_sequence, iv.name) otl_sequence,
147: iv.display_sequence
148: from pay_input_values_f iv,
149: pay_input_values_f_tl ivtl
150: --
151: where p_effective_date between iv.effective_start_date
152: and iv.effective_end_date
153: and iv.element_type_id = p_element_type_id

Line 1475: name PAY_INPUT_VALUES_F_TL.NAME%TYPE, --FORMS60

1471:
1472: -- Bug 12993528
1473: TYPE input_value_record IS RECORD
1474: (sequence PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE,
1475: name PAY_INPUT_VALUES_F_TL.NAME%TYPE, --FORMS60
1476: lookup PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE,
1477: otl_sequence NUMBER );
1478:
1479: TYPE input_values_table IS TABLE OF input_value_record