DBA Data[Home] [Help]

APPS.PER_JP_CMA_UTILITY_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 250: pay_element_links_f pel,

246: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 8, peev.screen_entry_value, NULL))), 0) equivalent_cost,
247: substrb(min(decode(piv.display_sequence, 9, peev.screen_entry_value, NULL)), 1, 6) pay_start,
248: substrb(min(decode(piv.display_sequence, 10, peev.screen_entry_value, NULL)), 1, 6) pay_end
249: from pay_element_types_f pet,
250: pay_element_links_f pel,
251: pay_element_entries_f pee,
252: pay_element_entry_values_f peev,
253: pay_input_values_f piv
254: where pet.element_name = c_car_element_name

Line 334: pay_element_links_f pel,

330: substrb(min(decode(piv.display_sequence, 8, peev.screen_entry_value, NULL)), 1, 6) pay_start,
331: substrb(min(decode(piv.display_sequence, 9, peev.screen_entry_value, NULL)), 1, 6) pay_end,
332: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 10, peev.screen_entry_value, NULL))), 0) si_month
333: from pay_element_types_f pet,
334: pay_element_links_f pel,
335: pay_element_entries_f pee,
336: pay_element_entry_values_f peev,
337: pay_input_values_f piv
338: where pet.element_name = c_train_element_name