APPS.PAY_FR_CPAM_PREPROCESSOR dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 76: pay_input_values_f piv, pay_element_entry_values_f eev

72: max(decode(eev.input_value_id,g_info_net_rt_iv_id
73: ,to_number(eev.screen_entry_value)
74: ,NULL)) Net_Daily_Rate
75: FROM pay_element_types_f pet, pay_element_entries_f pee,
76: pay_input_values_f piv, pay_element_entry_values_f eev
77: WHERE pee.element_entry_id = eev.element_entry_id
78: and pet.element_type_id = piv.element_type_id
79: and piv.input_value_id = eev.input_value_id
80: and pet.element_name = 'FR_SICKNESS_CPAM_INFO'

Line 111: pay_input_values_f piv, pay_element_entry_values_f pev

107:
108: CURSOR C_info_entries(p_assignment_id IN Number, p_start_date IN Date, p_end_date IN Date, p_curr_entry_id IN Number) IS
109: SELECT pev.effective_start_date
110: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet,
111: pay_input_values_f piv, pay_element_entry_values_f pev
112: WHERE pee.element_link_id = pel.element_link_id
113: AND pet.element_type_id = pel.element_type_id
114: AND pee.element_entry_id= pev.element_entry_id
115: AND pet.element_type_id = piv.element_type_id

Line 424: UPDATE PAY_ELEMENT_ENTRY_VALUES_F SET screen_entry_value = rec_input_values.Days

420: END IF; -- Info Entry Chk
421:
422: -- #3030587
423: -- Setting value for INFO element's input value Days
424: UPDATE PAY_ELEMENT_ENTRY_VALUES_F SET screen_entry_value = rec_input_values.Days
425: WHERE element_entry_id = p_element_entry_id
426: AND input_value_id = g_info_days_iv_id;
427:
428: IF C_info_entry%ISOPEN THEN