DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on PAY_INPUT_VALUES_F

Line 357: from pay_input_values_f piv,

353: min(decode(piv.display_sequence, 7, peev.screen_entry_value)) salary_payer_address_kana,
354: min(decode(piv.display_sequence, 8, peev.screen_entry_value)) salary_payer_address_kanji,
355: min(decode(piv.display_sequence, 9, peev.screen_entry_value)) salary_payer_name_kana,
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

Line 830: pay_input_values_f piv

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
832: and pel.business_group_id = p_business_group_id
833: and p_effective_date
834: between pel.effective_start_date and pel.effective_end_date