APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 369: pay_element_entry_values_f peev,

365: hr_jp_standard_pkg.to_hankaku(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 888: from pay_element_entry_values_f peev

884: between piv.effective_start_date and piv.effective_end_date
885: and not exists(
886: /* If required, add hint in the following sql. */
887: select null
888: from pay_element_entry_values_f peev
889: where peev.element_entry_id = pee.element_entry_id
890: and peev.effective_start_date = pee.effective_start_date
891: and peev.effective_end_date = pee.effective_end_date
892: and peev.input_value_id = piv.input_value_id);

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

892: and peev.input_value_id = piv.input_value_id);
893: --
894: hr_utility.trace('assignment_id : ' || p_assignment_id);
895: hr_utility.trace('element_type_id : ' || p_element_type_id);
896: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
897: --
898: -- Check RR_SPARSE legislation rule
899: --
900: pay_core_utils.get_legislation_rule(