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_REPORT_PKG dependencies on DUAL

Line 275: o_individual_pension_prem number,

271: a_sp_widow_exm number,
272: a_working_student_exm number,
273: o_dep_exm number,
274: o_spouse_income number,
275: o_individual_pension_prem number,
276: o_long_term_nonlife_ins_prem number,
277: o_small_comp_mut_aid_prem number,
278: o_national_pension_prem number,
279: o_income_exm number,

Line 1442: -- from dual

1438: -- end if;
1439: ----
1440: -- p_sqlstr :=
1441: -- 'select 1
1442: -- from dual
1443: -- where :payroll_action_id < 0';
1444: ----
1445: --else
1446: --

Line 1558: from dual))

1554: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
1555: and hou.organization_id <> hou.business_group_id
1556: union
1557: select g_organization_id
1558: from dual))
1559: or (g_organization_id is not null
1560: and nvl(g_inc_org_hier_flag,'N') = 'N'
1561: and pjia.organization_id = g_organization_id))
1562: and ((g_inc_term_flag = 'N'

Line 1629: from dual))

1625: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
1626: and hou.organization_id <> hou.business_group_id
1627: union
1628: select g_organization_id
1629: from dual))
1630: or (g_organization_id is not null
1631: and nvl(g_inc_org_hier_flag,'N') = 'N'
1632: and pjia.organization_id = g_organization_id))
1633: and ((g_inc_term_flag = 'N'

Line 1903: from dual;

1899: if l_ass_valid then
1900: --
1901: select pay_assignment_actions_s.nextval
1902: into l_assignment_action_id
1903: from dual;
1904: --
1905: hr_nonrun_asact.insact(
1906: lockingactid => l_assignment_action_id,
1907: assignid => g_ass_ind_tbl(l_ass_id_tbl(t)).assignment_id,

Line 2075: pjiyd.individual_pension_prem,

2071: pjiyd.sp_widow_exm,
2072: pjiyd.working_student_exm,
2073: pjiyd.dep_exm,
2074: pjiyd.spouse_income,
2075: pjiyd.individual_pension_prem,
2076: pjiyd.long_term_nonlife_ins_prem,
2077: pjiyd.small_comp_mut_aid_prem,
2078: pjiyd.national_pension_prem,
2079: pjiyd.income_exm,

Line 2218: from dual))

2214: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
2215: and hou.organization_id <> hou.business_group_id
2216: union
2217: select g_organization_id
2218: from dual))
2219: or (g_organization_id is not null
2220: and nvl(g_inc_org_hier_flag,'N') = 'N'
2221: and pjia.organization_id = g_organization_id))
2222: and ((g_inc_term_flag = 'N'

Line 2731: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_individual_pension_prem := l_csr_data_ass.individual_pension_prem;

2727: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_sp_widow_exm := l_csr_data_ass.sp_widow_exm;
2728: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_working_student_exm := l_csr_data_ass.working_student_exm;
2729: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_dep_exm := l_csr_data_ass.dep_exm;
2730: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_spouse_income := l_csr_data_ass.spouse_income;
2731: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_individual_pension_prem := l_csr_data_ass.individual_pension_prem;
2732: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_long_term_nonlife_ins_prem := l_csr_data_ass.long_term_nonlife_ins_prem;
2733: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_small_comp_mut_aid_prem := l_csr_data_ass.small_comp_mut_aid_prem;
2734: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_national_pension_prem := l_csr_data_ass.national_pension_prem;
2735: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_income_exm := l_csr_data_ass.income_exm;

Line 4658: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y17' ,g_body_tbl(p_assignment_action_id).o_individual_pension_prem ));

4654: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y13' ,g_body_tbl(p_assignment_action_id).o_spouse_sp_exm ));
4655: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y14' ,g_body_tbl(p_assignment_action_id).o_dep_exm ));
4656: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y15' ,g_body_tbl(p_assignment_action_id).o_income_exm ));
4657: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y16' ,g_body_tbl(p_assignment_action_id).o_spouse_income ));
4658: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y17' ,g_body_tbl(p_assignment_action_id).o_individual_pension_prem ));
4659: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y18' ,g_body_tbl(p_assignment_action_id).o_long_term_nonlife_ins_prem ));
4660: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y19' ,g_body_tbl(p_assignment_action_id).o_small_comp_mut_aid_prem ));
4661: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y20' ,g_body_tbl(p_assignment_action_id).o_national_pension_prem ));
4662: hr_utility.trace(pay_jp_report_pkg.add_tag_m('y21' ,g_body_tbl(p_assignment_action_id).o_net_txbl_income ));

Line 5833: pay_jp_report_pkg.add_tag_m('y17' ,g_body_tbl(p_assignment_action_id).o_individual_pension_prem )||c_eol||

5829: pay_jp_report_pkg.add_tag_m('y13' ,g_body_tbl(p_assignment_action_id).o_spouse_sp_exm )||c_eol||
5830: pay_jp_report_pkg.add_tag_m('y14' ,g_body_tbl(p_assignment_action_id).o_dep_exm )||c_eol||
5831: pay_jp_report_pkg.add_tag_m('y15' ,g_body_tbl(p_assignment_action_id).o_income_exm )||c_eol||
5832: pay_jp_report_pkg.add_tag_m('y16' ,g_body_tbl(p_assignment_action_id).o_spouse_income )||c_eol||
5833: pay_jp_report_pkg.add_tag_m('y17' ,g_body_tbl(p_assignment_action_id).o_individual_pension_prem )||c_eol||
5834: pay_jp_report_pkg.add_tag_m('y18' ,g_body_tbl(p_assignment_action_id).o_long_term_nonlife_ins_prem )||c_eol||
5835: pay_jp_report_pkg.add_tag_m('y19' ,g_body_tbl(p_assignment_action_id).o_small_comp_mut_aid_prem )||c_eol||
5836: pay_jp_report_pkg.add_tag_m('y20' ,g_body_tbl(p_assignment_action_id).o_national_pension_prem )||c_eol||
5837: pay_jp_report_pkg.add_tag_m('y21' ,g_body_tbl(p_assignment_action_id).o_net_txbl_income )||c_eol||

Line 6607: pay_jp_report_pkg.add_tag_m('y17' ,g_body_tbl(p_assignment_action_id).o_individual_pension_prem )||c_eol||

6603: pay_jp_report_pkg.add_tag_m('y13' ,g_body_tbl(p_assignment_action_id).o_spouse_sp_exm )||c_eol||
6604: pay_jp_report_pkg.add_tag_m('y14' ,g_body_tbl(p_assignment_action_id).o_dep_exm )||c_eol||
6605: pay_jp_report_pkg.add_tag_m('y15' ,g_body_tbl(p_assignment_action_id).o_income_exm )||c_eol||
6606: pay_jp_report_pkg.add_tag_m('y16' ,g_body_tbl(p_assignment_action_id).o_spouse_income )||c_eol||
6607: pay_jp_report_pkg.add_tag_m('y17' ,g_body_tbl(p_assignment_action_id).o_individual_pension_prem )||c_eol||
6608: pay_jp_report_pkg.add_tag_m('y18' ,g_body_tbl(p_assignment_action_id).o_long_term_nonlife_ins_prem )||c_eol||
6609: pay_jp_report_pkg.add_tag_m('y19' ,g_body_tbl(p_assignment_action_id).o_small_comp_mut_aid_prem )||c_eol||
6610: pay_jp_report_pkg.add_tag_m('y20' ,g_body_tbl(p_assignment_action_id).o_national_pension_prem )||c_eol||
6611: pay_jp_report_pkg.add_tag_m('y21' ,g_body_tbl(p_assignment_action_id).o_net_txbl_income )||c_eol||