DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_JP_ITWB_BON_ACT_EFD_V

Line 8304: pay_jp_itwb_bon_act_efd_v pyjibae

8300: decode(sign(to_number(to_char(nvl(pyjibae.col_cnt13,g_effective_som),'MM')) - to_number(to_char(g_effective_som,'MM'))),0,null,pyjibai.col_cnt13) col_cnt13,
8301: decode(sign(to_number(to_char(nvl(pyjibae.col_cnt14,g_effective_som),'MM')) - to_number(to_char(g_effective_som,'MM'))),0,null,pyjibai.col_cnt14) col_cnt14,
8302: decode(sign(to_number(to_char(nvl(pyjibae.col_cnt15,g_effective_som),'MM')) - to_number(to_char(g_effective_som,'MM'))),0,null,pyjibai.col_cnt15) col_cnt15
8303: from pay_jp_itwb_bon_act_id_v pyjibai,
8304: pay_jp_itwb_bon_act_efd_v pyjibae
8305: where pyjibai.assignment_action_id = p_arch_assignment_action_id_o
8306: and pyjibae.assignment_action_id = pyjibai.assignment_action_id
8307: and pyjibae.effective_date = pyjibai.effective_date;
8308: --