DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 405: pay_element_links_f pel

401: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) salary_payer_name_kanji
402: from pay_input_values_f piv,
403: pay_element_entry_values_f peev,
404: pay_element_entries_f pee,
405: pay_element_links_f pel
406: where pel.element_type_id = g_prev_job_elm
407: and pel.business_group_id + 0 = p_business_group_id
408: and p_date_earned
409: between pel.effective_start_date and pel.effective_end_date

Line 1082: from pay_element_links_f pel,

1078: min(decode(piv.display_sequence, 9, peev.screen_entry_value)) wtm_description2,
1079: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) wtm_description3,
1080: min(decode(piv.display_sequence, 11, peev.screen_entry_value)) wtm_description4,
1081: min(decode(piv.display_sequence, 12, peev.screen_entry_value)) wtm_description5
1082: from pay_element_links_f pel,
1083: pay_element_entries_f pee,
1084: pay_element_entry_values_f peev,
1085: pay_input_values_f piv
1086: where pel.element_type_id = g_desc_element_type_id