APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 369: pay_element_entry_values_f peev,

365: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) employer_name
366: from pay_element_types_f pet,
367: pay_element_links_f pel,
368: pay_element_entries_f pee,
369: pay_element_entry_values_f peev,
370: pay_input_values_f piv
371: where pet.element_name = 'YEA_PREV_EMP_INFO'
372: and pet.legislation_code = 'JP'
373: and pel.element_type_id = pet.element_type_id

Line 851: insert into pay_element_entry_values_f(

847: if p_element_type_id is not null then
848: --
849: -- Before running this SQL, PAY_LINK_INPUT_VALUES needs to be populated.
850: --
851: insert into pay_element_entry_values_f(
852: ELEMENT_ENTRY_VALUE_ID,
853: EFFECTIVE_START_DATE,
854: EFFECTIVE_END_DATE,
855: INPUT_VALUE_ID,

Line 882: from pay_element_entry_values_f peev

878: between piv.effective_start_date and piv.effective_end_date
879: and not exists(
880: /* If required, add hint in the following sql. */
881: select null
882: from pay_element_entry_values_f peev
883: where peev.element_entry_id = pee.element_entry_id
884: and peev.effective_start_date = pee.effective_start_date
885: and peev.effective_end_date = pee.effective_end_date
886: and peev.input_value_id = piv.input_value_id);

Line 890: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');

886: and peev.input_value_id = piv.input_value_id);
887: --
888: hr_utility.trace('assignment_id : ' || p_assignment_id);
889: hr_utility.trace('element_type_id : ' || p_element_type_id);
890: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
891: --
892: -- Check RR_SPARSE legislation rule
893: --
894: pay_core_utils.get_legislation_rule(