eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_JP_ITWB_BON_ACT_ID_V

Line 8282: from pay_jp_itwb_bon_act_id_v

8278: col_cnt12,
8279: col_cnt13,
8280: col_cnt14,
8281: col_cnt15
8282: from pay_jp_itwb_bon_act_id_v
8283: where assignment_action_id = p_arch_assignment_action_id_o;
8284: --
8285: cursor csr_ass_bon_exc(
8286: p_arch_assignment_action_id_o in number)

Line 8303: from pay_jp_itwb_bon_act_id_v pyjibai,

8299: decode(sign(to_number(to_char(nvl(pyjibae.col_cnt12,g_effective_som),'MM')) - to_number(to_char(g_effective_som,'MM'))),0,null,pyjibai.col_cnt12) col_cnt12,
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;