APPS.PAY_AU_SGC_PKG dependencies on PAY_BALANCE_PKG

Line 212: l_sgc_contribution := pay_balance_pkg.get_value(g_super_guarantee_bal_id_mtd,

208:
209:
210: ------------------ /* to get the SGC Contribution for the month */--------------------------------
211: /*Bug 2610141 --- Added this portion to accomodate for the BRA changes */
212: l_sgc_contribution := pay_balance_pkg.get_value(g_super_guarantee_bal_id_mtd,
213: l_assignment_action_id,
214: p_registered_employer,null,null,null,null);
215:
216:

Line 230: l_salary := pay_balance_pkg.get_value(l_bal_id_mtd,

226: exit when bal%notfound;
227: fetch bal into l_bal_id_min_superable_sal; /*Bug 2610141 */
228: open bal_id_mtd(l_bal_id_min_superable_sal,p_legislation_code); /*Bug 2610141 */
229: fetch bal_id_mtd into l_bal_id_mtd;
230: l_salary := pay_balance_pkg.get_value(l_bal_id_mtd,
231: l_assignment_action_id,
232: p_registered_employer,null,null,null,null); /*Bug 2610141 */
233: IF bal%rowcount = 1 then
234: l_bal_id := l_bal_id_min_superable_sal;

Line 254: l_SGC_qtd := pay_balance_pkg.get_value(l_super_guarantee_bal_id_qtd,

250: OPEN bal_id_qtd(l_bal_id,p_legislation_code);
251: FETCH bal_id_qtd INTO l_super_guarantee_bal_id_qtd;
252: CLOSE bal_id_qtd;
253:
254: l_SGC_qtd := pay_balance_pkg.get_value(l_super_guarantee_bal_id_qtd,
255: l_assignment_action_id,
256: p_registered_employer,null,null,null,null);
257:
258: /*Bug 2610141 --- Added portion for the BRA changes ends here*/

Line 378: p_sgc_contribution := pay_balance_pkg.get_value(g_super_guarantee_bal_id_mtd,

374:
375:
376: -------------- /* to get the SGC Contribution for the month */----------------------
377: /*Bug 2610141 --- Added this portion to accomodate for the BRA changes */
378: p_sgc_contribution := pay_balance_pkg.get_value(g_super_guarantee_bal_id_mtd,
379: l_assignment_action_id,
380: p_registered_employer,null,null,null,null);
381:
382: /*Bug 2610141 --- Added portion for the BRA changes ends here*/

Line 395: l_salary := pay_balance_pkg.get_value(l_bal_id_mtd,

391: exit when bal%notfound;
392: fetch bal into l_bal_id_min_superable_sal;
393: open bal_id_mtd(l_bal_id_min_superable_sal,p_legislation_code); /*Bug 2610141 */
394: fetch bal_id_mtd into l_bal_id_mtd;
395: l_salary := pay_balance_pkg.get_value(l_bal_id_mtd,
396: l_assignment_action_id,
397: p_registered_employer,null,null,null,null); /*Bug 2610141 */
398: IF bal%rowcount = 1 then
399: l_bal_id := l_bal_id_min_superable_sal;

Line 440: l_SGC_qtd := pay_balance_pkg.get_value(l_super_guarantee_bal_id_qtd,

436: OPEN bal_id_qtd(l_bal_id,'AU');
437: FETCH bal_id_qtd INTO l_super_guarantee_bal_id_qtd;
438: CLOSE bal_id_qtd;
439:
440: l_SGC_qtd := pay_balance_pkg.get_value(l_super_guarantee_bal_id_qtd,
441: l_assignment_action_id,
442: p_registered_employer,null,null,null,null);
443:
444: /*Bug 2610141 --- Added portion for the BRA changes ends here*/