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

Line 25: from dual;

21: end if;
22: --
23: select pay_action_information_s.nextval
24: into l_action_information_id
25: from dual;
26: --
27: if g_debug then
28: hr_utility.set_location(l_proc,1000);
29: end if;

Line 7537: p_individual_pension_prem in number,

7533: p_sp_widow_exm in number,
7534: p_working_student_exm in number,
7535: p_dep_exm in number,
7536: p_spouse_income in number,
7537: p_individual_pension_prem in number,
7538: p_long_term_nonlife_ins_prem in number,
7539: p_small_comp_mut_aid_prem in number,
7540: p_national_pension_prem in number,
7541: p_income_exm in number,

Line 7620: fnd_number.number_to_canonical(p_individual_pension_prem),

7616: fnd_number.number_to_canonical(p_sp_widow_exm),
7617: fnd_number.number_to_canonical(p_working_student_exm),
7618: fnd_number.number_to_canonical(p_dep_exm),
7619: fnd_number.number_to_canonical(p_spouse_income),
7620: fnd_number.number_to_canonical(p_individual_pension_prem),
7621: fnd_number.number_to_canonical(p_long_term_nonlife_ins_prem),
7622: fnd_number.number_to_canonical(p_small_comp_mut_aid_prem),
7623: fnd_number.number_to_canonical(p_national_pension_prem),
7624: fnd_number.number_to_canonical(p_income_exm));

Line 7664: p_individual_pension_prem in number,

7660: p_sp_widow_exm in number,
7661: p_working_student_exm in number,
7662: p_dep_exm in number,
7663: p_spouse_income in number,
7664: p_individual_pension_prem in number,
7665: p_long_term_nonlife_ins_prem in number,
7666: p_small_comp_mut_aid_prem in number,
7667: p_national_pension_prem in number,
7668: p_income_exm in number,

Line 7809: nvl(fnd_number.number_to_canonical(p_individual_pension_prem),'X'),

7805: nvl(fnd_number.number_to_canonical(p_spouse_income),'X'),
7806: action_information23,
7807: fnd_number.number_to_canonical(p_spouse_income)),
7808: action_information24 = decode(nvl(action_information24,'X'),
7809: nvl(fnd_number.number_to_canonical(p_individual_pension_prem),'X'),
7810: action_information24,
7811: fnd_number.number_to_canonical(p_individual_pension_prem)),
7812: action_information25 = decode(nvl(action_information25,'X'),
7813: nvl(fnd_number.number_to_canonical(p_long_term_nonlife_ins_prem),'X'),

Line 7811: fnd_number.number_to_canonical(p_individual_pension_prem)),

7807: fnd_number.number_to_canonical(p_spouse_income)),
7808: action_information24 = decode(nvl(action_information24,'X'),
7809: nvl(fnd_number.number_to_canonical(p_individual_pension_prem),'X'),
7810: action_information24,
7811: fnd_number.number_to_canonical(p_individual_pension_prem)),
7812: action_information25 = decode(nvl(action_information25,'X'),
7813: nvl(fnd_number.number_to_canonical(p_long_term_nonlife_ins_prem),'X'),
7814: action_information25,
7815: fnd_number.number_to_canonical(p_long_term_nonlife_ins_prem)),

Line 7880: <> nvl(fnd_number.number_to_canonical(p_individual_pension_prem),'X')

7876: <> nvl(fnd_number.number_to_canonical(p_dep_exm),'X')
7877: or nvl(action_information23,'X')
7878: <> nvl(fnd_number.number_to_canonical(p_spouse_income),'X')
7879: or nvl(action_information24,'X')
7880: <> nvl(fnd_number.number_to_canonical(p_individual_pension_prem),'X')
7881: or nvl(action_information25,'X')
7882: <> nvl(fnd_number.number_to_canonical(p_long_term_nonlife_ins_prem),'X')
7883: or nvl(action_information26,'X')
7884: <> nvl(fnd_number.number_to_canonical(p_small_comp_mut_aid_prem),'X')

Line 7930: p_individual_pension_prem in number,

7926: p_sp_widow_exm in number,
7927: p_working_student_exm in number,
7928: p_dep_exm in number,
7929: p_spouse_income in number,
7930: p_individual_pension_prem in number,
7931: p_long_term_nonlife_ins_prem in number,
7932: p_small_comp_mut_aid_prem in number,
7933: p_national_pension_prem in number,
7934: p_income_exm in number,

Line 8050: action_information24 = decode(nvl(fnd_number.number_to_canonical(p_individual_pension_prem),'X'),

8046: fnd_number.number_to_canonical(p_dep_exm)),
8047: action_information23 = decode(nvl(fnd_number.number_to_canonical(p_spouse_income),'X'),
8048: 'X',action_information23,
8049: fnd_number.number_to_canonical(p_spouse_income)),
8050: action_information24 = decode(nvl(fnd_number.number_to_canonical(p_individual_pension_prem),'X'),
8051: 'X',action_information24,
8052: fnd_number.number_to_canonical(p_individual_pension_prem)),
8053: action_information25 = decode(nvl(fnd_number.number_to_canonical(p_long_term_nonlife_ins_prem),'X'),
8054: 'X',action_information25,

Line 8052: fnd_number.number_to_canonical(p_individual_pension_prem)),

8048: 'X',action_information23,
8049: fnd_number.number_to_canonical(p_spouse_income)),
8050: action_information24 = decode(nvl(fnd_number.number_to_canonical(p_individual_pension_prem),'X'),
8051: 'X',action_information24,
8052: fnd_number.number_to_canonical(p_individual_pension_prem)),
8053: action_information25 = decode(nvl(fnd_number.number_to_canonical(p_long_term_nonlife_ins_prem),'X'),
8054: 'X',action_information25,
8055: fnd_number.number_to_canonical(p_long_term_nonlife_ins_prem)),
8056: action_information26 = decode(nvl(fnd_number.number_to_canonical(p_small_comp_mut_aid_prem),'X'),