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_KR_YEA_SSHR_UTILS_PKG dependencies on PAY_BALANCE_PKG

Line 99: l_total_taxable := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)+

95: raise no_data_found;
96: end if;
97: CLOSE csr_get_def_bal_id;
98:
99: l_total_taxable := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)+
100: nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
101:
102: return(l_total_taxable);
103: end;

Line 100: nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);

96: end if;
97: CLOSE csr_get_def_bal_id;
98:
99: l_total_taxable := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)+
100: nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
101:
102: return(l_total_taxable);
103: end;
104: -----------------------------------------------------------------------------------

Line 126: l_total_itax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)

122: raise no_data_found;
123: end if;
124: CLOSE csr_get_def_bal_id;
125:
126: l_total_itax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
127: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
128:
129: return(l_total_itax);
130: end;

Line 127: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);

123: end if;
124: CLOSE csr_get_def_bal_id;
125:
126: l_total_itax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
127: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
128:
129: return(l_total_itax);
130: end;
131: -----------------------------------------------------------------------------------

Line 153: l_total_rtax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)

149: CLOSE csr_get_def_bal_id;
150: raise no_data_found;
151: end if;
152: CLOSE csr_get_def_bal_id;
153: l_total_rtax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
154: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
155: return(l_total_rtax);
156: end;
157: -----------------------------------------------------------------------------------

Line 154: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);

150: raise no_data_found;
151: end if;
152: CLOSE csr_get_def_bal_id;
153: l_total_rtax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
154: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
155: return(l_total_rtax);
156: end;
157: -----------------------------------------------------------------------------------
158: -- Bug : 4568233

Line 179: l_total_stax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)

175: raise no_data_found;
176: end if;
177: CLOSE csr_get_def_bal_id;
178:
179: l_total_stax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
180: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
181: return(l_total_stax);
182: end;
183: -----------------------------------------------------------------------------------

Line 180: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);

176: end if;
177: CLOSE csr_get_def_bal_id;
178:
179: l_total_stax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
180: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
181: return(l_total_stax);
182: end;
183: -----------------------------------------------------------------------------------
184: -- Gets the YTD balance for Overseas Earnings

Line 201: l_ovs_bal := nvl(pay_balance_pkg.get_value(l_def_balance_id,p_assignment_id,p_effective_date),0);

197: raise no_data_found;
198: end if;
199: CLOSE csr_get_def_bal_id_ytd;
200:
201: l_ovs_bal := nvl(pay_balance_pkg.get_value(l_def_balance_id,p_assignment_id,p_effective_date),0);
202:
203: return(l_ovs_bal);
204: end;
205: -----------------------------------------------------------------------------------

Line 1225: p_hi_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,

1221: --
1222: open csr_get_def_bal_id_ytd('HI_PREM_EE') ;
1223: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1224: if csr_get_def_bal_id_ytd%found then
1225: p_hi_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1226: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1227: end if ;
1228: close csr_get_def_bal_id_ytd ;
1229: --

Line 1234: p_ltci_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,

1230: -- Bug 7260606
1231: open csr_get_def_bal_id_ytd('LTCI_PREM_EE') ;
1232: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1233: if csr_get_def_bal_id_ytd%found then
1234: p_ltci_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1235: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1236: end if ;
1237: close csr_get_def_bal_id_ytd ;
1238: -- End of Bug 7260606

Line 1243: p_ei_prem := pay_balance_pkg.get_value(l_def_bal_id,

1239: --
1240: open csr_get_def_bal_id_ytd('EI_PREM') ;
1241: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1242: if csr_get_def_bal_id_ytd%found then
1243: p_ei_prem := pay_balance_pkg.get_value(l_def_bal_id,
1244: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1245: end if ;
1246: close csr_get_def_bal_id_ytd ;
1247: --

Line 1251: p_np_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,

1247: --
1248: open csr_get_def_bal_id_ytd('NP_PREM_EE') ;
1249: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1250: if csr_get_def_bal_id_ytd%found then
1251: p_np_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1252: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1253: end if ;
1254: close csr_get_def_bal_id_ytd ;
1255: --

Line 1260: p_pen_prem_bal := pay_balance_pkg.get_value(l_def_bal_id,

1256: -- Bug 6024342
1257: open csr_get_def_bal_id_ytd('Pension Premium') ;
1258: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1259: if csr_get_def_bal_id_ytd%found then
1260: p_pen_prem_bal := pay_balance_pkg.get_value(l_def_bal_id,
1261: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1262: end if ;
1263: close csr_get_def_bal_id_ytd ;
1264: --