DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 360: pay_element_links_f pel

356: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) salary_payer_name_kanji
357: from pay_input_values_f piv,
358: pay_element_entry_values_f peev,
359: pay_element_entries_f pee,
360: pay_element_links_f pel
361: where pel.element_type_id = g_prev_job_elm
362: and pel.business_group_id + 0 = p_business_group_id
363: and p_date_earned
364: between pel.effective_start_date and pel.effective_end_date

Line 827: from pay_element_links_f pel,

823: min(decode(piv.display_sequence, 9, peev.screen_entry_value)) wtm_description2,
824: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) wtm_description3,
825: min(decode(piv.display_sequence, 11, peev.screen_entry_value)) wtm_description4,
826: min(decode(piv.display_sequence, 12, peev.screen_entry_value)) wtm_description5
827: from pay_element_links_f pel,
828: pay_element_entries_f pee,
829: pay_element_entry_values_f peev,
830: pay_input_values_f piv
831: where pel.element_type_id = g_desc_element_type_id