DBA Data[Home] [Help]

APPS.PQP_US_FF_FUNCTIONS dependencies on PAY_BALANCE_PKG

Line 239: pay_balance_pkg.set_context('tax_unit_id', l_tax_unit_id);

235: END IF;
236: --+
237: --+ set the tax unit id context
238: --+
239: pay_balance_pkg.set_context('tax_unit_id', l_tax_unit_id);
240: --+
241: --+ fetch the defined balance it
242: --+
243: FOR c_rec IN c_defined_bal LOOP

Line 253: pay_balance_pkg.set_context('jurisdiction_code', l_jd_code);

249: IF NVL(p_state_code, 'NULL') <> 'NULL' THEN
250: FOR c_rec IN c_jurisdiction LOOP
251: l_jd_code := c_rec.jurisdiction_code;
252: END LOOP;
253: pay_balance_pkg.set_context('jurisdiction_code', l_jd_code);
254: END IF;
255: --+
256: --+ Finally get the actual balance
257: --+

Line 258: l_amt := pay_balance_pkg.get_value(l_def_bal_id,

254: END IF;
255: --+
256: --+ Finally get the actual balance
257: --+
258: l_amt := pay_balance_pkg.get_value(l_def_bal_id,
259: p_assignment_id,
260: l_effective_date);
261: --+
262: RETURN l_amt;

Line 391: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id);

387: END LOOP;
388:
389: --+ Set up the GRE and Jurisdicton context
390:
391: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id);
392:
393: IF p_balance_name <> 'Non W2 FIT Withheld' THEN
394: pay_balance_pkg.set_context('jurisdiction_code',p_jurisdiction_code);
395: END IF;

Line 394: pay_balance_pkg.set_context('jurisdiction_code',p_jurisdiction_code);

390:
391: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id);
392:
393: IF p_balance_name <> 'Non W2 FIT Withheld' THEN
394: pay_balance_pkg.set_context('jurisdiction_code',p_jurisdiction_code);
395: END IF;
396:
397: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
398: p_assignment_action_id);

Line 397: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,

393: IF p_balance_name <> 'Non W2 FIT Withheld' THEN
394: pay_balance_pkg.set_context('jurisdiction_code',p_jurisdiction_code);
395: END IF;
396:
397: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
398: p_assignment_action_id);
399: END IF;
400:
401: RETURN l_balance_amount;

Line 634: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre);

630: -- on 13-Jun-2002 tmehra
631: -- pay_us_balance_view_pkg.set_context('TAX_UNIT_ID',p_gre);
632: -- pay_us_balance_view_pkg.set_context('DATE_EARNED',p_end_date);
633:
634: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre);
635: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_end_date));
636: pay_balance_pkg.set_context('BALANCE_DATE',fnd_date.date_to_canonical(p_start_date));
637:
638: IF p_bal_name = 'Non W2 FIT' THEN

Line 635: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_end_date));

631: -- pay_us_balance_view_pkg.set_context('TAX_UNIT_ID',p_gre);
632: -- pay_us_balance_view_pkg.set_context('DATE_EARNED',p_end_date);
633:
634: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre);
635: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_end_date));
636: pay_balance_pkg.set_context('BALANCE_DATE',fnd_date.date_to_canonical(p_start_date));
637:
638: IF p_bal_name = 'Non W2 FIT' THEN
639:

Line 636: pay_balance_pkg.set_context('BALANCE_DATE',fnd_date.date_to_canonical(p_start_date));

632: -- pay_us_balance_view_pkg.set_context('DATE_EARNED',p_end_date);
633:
634: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre);
635: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_end_date));
636: pay_balance_pkg.set_context('BALANCE_DATE',fnd_date.date_to_canonical(p_start_date));
637:
638: IF p_bal_name = 'Non W2 FIT' THEN
639:
640: IF p_dim = 'CTD' THEN

Line 652: l_bal_amt := pay_balance_pkg.get_value(l_defined_bal_id

648: END IF;
649:
650: l_defined_bal_id := get_defined_bal_id ('Non W2 FIT Withheld',l_dimension);
651:
652: l_bal_amt := pay_balance_pkg.get_value(l_defined_bal_id
653: ,l_asg_action_id);
654: ELSIF p_bal_name = 'Non W2 SIT' THEN
655:
656: IF p_dim = 'CTD' THEN

Line 668: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);

664: END IF;
665:
666: l_defined_bal_id := get_defined_bal_id ('SIT Alien Withheld',l_dimension);
667:
668: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);
669:
670: l_bal_amt := pay_balance_pkg.get_value(l_defined_bal_id
671: ,l_asg_action_id);
672:

Line 670: l_bal_amt := pay_balance_pkg.get_value(l_defined_bal_id

666: l_defined_bal_id := get_defined_bal_id ('SIT Alien Withheld',l_dimension);
667:
668: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);
669:
670: l_bal_amt := pay_balance_pkg.get_value(l_defined_bal_id
671: ,l_asg_action_id);
672:
673:
674: ELSIF p_bal_name = 'Non W2 FIT Wages' THEN

Line 690: + pay_balance_pkg.get_value(l_defined_bal_id

686: l_defined_bal_id := get_defined_bal_id ('FIT Alien Subj Whable',l_dimension);
687: l_def_pre_tax_id := get_defined_bal_id ('FIT Non W2 Pre Tax Dedns',l_dimension);
688:
689: l_bal_amt := l_bal_amt
690: + pay_balance_pkg.get_value(l_defined_bal_id
691: ,l_asg_action_id)
692: - pay_balance_pkg.get_value(l_def_pre_tax_id
693: ,l_asg_action_id);
694:

Line 692: - pay_balance_pkg.get_value(l_def_pre_tax_id

688:
689: l_bal_amt := l_bal_amt
690: + pay_balance_pkg.get_value(l_defined_bal_id
691: ,l_asg_action_id)
692: - pay_balance_pkg.get_value(l_def_pre_tax_id
693: ,l_asg_action_id);
694:
695: ELSIF p_bal_name = 'Non W2 SIT Wages' THEN
696:

Line 710: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);

706:
707: l_defined_bal_id := get_defined_bal_id ('SIT Alien Subj Whable',l_dimension);
708: l_def_pre_tax_id := get_defined_bal_id ('SIT Non W2 Pre Tax Dedns',l_dimension);
709:
710: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);
711:
712: l_bal_amt := l_bal_amt
713: + pay_balance_pkg.get_value(l_defined_bal_id
714: ,l_asg_action_id)

Line 713: + pay_balance_pkg.get_value(l_defined_bal_id

709:
710: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);
711:
712: l_bal_amt := l_bal_amt
713: + pay_balance_pkg.get_value(l_defined_bal_id
714: ,l_asg_action_id)
715: - pay_balance_pkg.get_value(l_def_pre_tax_id
716: ,l_asg_action_id);
717: END IF;

Line 715: - pay_balance_pkg.get_value(l_def_pre_tax_id

711:
712: l_bal_amt := l_bal_amt
713: + pay_balance_pkg.get_value(l_defined_bal_id
714: ,l_asg_action_id)
715: - pay_balance_pkg.get_value(l_def_pre_tax_id
716: ,l_asg_action_id);
717: END IF;
718:
719: