APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 6070: FROM pay_element_entry_values_f pef,

6066: ,c_period_end_date IN DATE ) IS
6067: SELECT fnd_number.canonical_to_number(nvl(screen_entry_value,'0')) perc_value
6068: ,pee.effective_start_date start_date
6069: ,pee.effective_end_date end_date
6070: FROM pay_element_entry_values_f pef,
6071: pay_element_entries_f pee
6072: WHERE pef.input_value_id = c_input_value_id
6073: AND pef.element_entry_id = pee.element_entry_id
6074: AND pef.effective_start_date = pee.effective_start_date

Line 7260: FROM pay_element_entry_values_f peev1,

7256: IS
7257: SELECT peev1.screen_entry_value basis,
7258: peev2.screen_entry_value paid,
7259: pay_paywsmee_pkg.get_original_date_earned(pee.element_entry_id) orig_date_earned
7260: FROM pay_element_entry_values_f peev1,
7261: pay_element_entry_values_f peev2,
7262: pay_element_entries_f pee,
7263: pay_retro_component_usages prcu,
7264: pay_retro_components prc,

Line 7261: pay_element_entry_values_f peev2,

7257: SELECT peev1.screen_entry_value basis,
7258: peev2.screen_entry_value paid,
7259: pay_paywsmee_pkg.get_original_date_earned(pee.element_entry_id) orig_date_earned
7260: FROM pay_element_entry_values_f peev1,
7261: pay_element_entry_values_f peev2,
7262: pay_element_entries_f pee,
7263: pay_retro_component_usages prcu,
7264: pay_retro_components prc,
7265: pay_element_span_usages pesu