APPS.PAY_TEMPLATE_IVS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 81: PAY_ELEMENT_ENTRY_VALUES_F

77:
78: The new New_Input_Value API needs to retrofit [date-effective] rows in
79: the following tables:
80: PAY_LINK_INPUT_VALUES_F
81: PAY_ELEMENT_ENTRY_VALUES_F
82: PAY_RUN_RESULT_VALUES
83: NOTE: These are the rows created for and by payroll runs.
84:
85:

Line 155: from pay_element_entry_values_f pev

151: over the life of the entry.
152:
153: select DISTINCT pev.effective_start_date,
154: pev.effective_end_date
155: from pay_element_entry_values_f pev
156: where pev.element_entry_id = l_element_entry_id
157: order by pev.effective_start_date;
158:
159:

Line 161: PAY_ELEMENT_ENTRY_VALUES_F row...MULTIPLE ROWS...

157: order by pev.effective_start_date;
158:
159:
160: 2c. For each date-effective row found in 2b, create date-effective
161: PAY_ELEMENT_ENTRY_VALUES_F row...MULTIPLE ROWS...
162: INSERT INTO pay_element_entry_values_f (
163: element_entry_value_id,
164: element_entry_id,
165: input_value_id,

Line 162: INSERT INTO pay_element_entry_values_f (

158:
159:
160: 2c. For each date-effective row found in 2b, create date-effective
161: PAY_ELEMENT_ENTRY_VALUES_F row...MULTIPLE ROWS...
162: INSERT INTO pay_element_entry_values_f (
163: element_entry_value_id,
164: element_entry_id,
165: input_value_id,
166: effective_start_date,

Line 243: from pay_element_entry_values_f pev

239:
240: CURSOR get_entry_values (p_entry_id NUMBER) IS
241: select pev.effective_start_date,
242: pev.effective_end_date
243: from pay_element_entry_values_f pev
244: where pev.element_entry_id = p_entry_id
245: order by pev.effective_start_date;
246:
247: CURSOR get_results (p_eletype_id NUMBER) IS

Line 355: PAY_ELEMENT_ENTRY_VALUES_F row...MULTIPLE ROWS...

351: LOOP
352:
353: /*
354: 2c. For each date-effective row found in 2b, create date-effective
355: PAY_ELEMENT_ENTRY_VALUES_F row...MULTIPLE ROWS...
356: */
357:
358: FETCH get_entry_values
359: INTO l_entry_eff_start,

Line 373: INSERT INTO pay_element_entry_values_f (

369: p_input_val_id => p_input_value_id);
370:
371: if already_exists = 0 then
372:
373: INSERT INTO pay_element_entry_values_f (
374: element_entry_value_id,
375: element_entry_id,
376: input_value_id,
377: effective_start_date,

Line 396: from pay_element_entry_values_f

392: else
393:
394: select count(0)
395: into entryval_exists
396: from pay_element_entry_values_f
397: where element_entry_value_id = already_exists
398: and effective_start_date = l_entry_eff_start;
399:
400: if entryval_exists = 0 then

Line 402: INSERT INTO pay_element_entry_values_f (

398: and effective_start_date = l_entry_eff_start;
399:
400: if entryval_exists = 0 then
401:
402: INSERT INTO pay_element_entry_values_f (
403: element_entry_value_id,
404: element_entry_id,
405: input_value_id,
406: effective_start_date,