APPS.HXT_BATCH_PROCESS dependencies on PAY_INPUT_VALUES_F

Line 108: from pay_input_values_f iv,

104: iv.lookup_type,
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

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 127: from pay_input_values_f iv,

123: iv.lookup_type,
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

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 148: from pay_input_values_f iv,

144: iv.lookup_type,
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

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 1474: (sequence PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE,

1470: l_line_ovn number;
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:

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

Line 1476: lookup PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE,

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
1480: INDEX BY BINARY_INTEGER;

Line 1492: pay_input_values_f PIV

1488: ,cp_assignment_id NUMBER
1489: ,cp_effective_date DATE) IS
1490: SELECT distinct PIV.name -- PIV.display_sequence
1491: FROM --pay_element_types_f PET
1492: pay_input_values_f PIV
1493: ,pay_accrual_plans PAP
1494: ,pay_net_calculation_rules PNCR
1495: WHERE--PET.element_type_id = cp_element_type_id
1496: --AND PET.element_type_id = PIV.element_type_id