DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on PAY_BALANCE_PKG

Line 3531: pay_balance_pkg.set_context('tax_unit_id', g_gre_org_id);

3527: --
3528: IF g_legislation_code = 'MX' AND
3529: g_extract_params(i).reporting_dimension = 'ASG_RUN' THEN
3530: -- Set the Balance Context
3531: pay_balance_pkg.set_context('tax_unit_id', g_gre_org_id);
3532: pay_balance_pkg.set_context('date_earned', g_action_effective_date);
3533: IF g_debug THEN
3534: hr_utility.set_location(' tax_unit_id: '||g_gre_org_id, 5);
3535: hr_utility.set_location(' date_earned: '||g_action_effective_date, 5);

Line 3532: pay_balance_pkg.set_context('date_earned', g_action_effective_date);

3528: IF g_legislation_code = 'MX' AND
3529: g_extract_params(i).reporting_dimension = 'ASG_RUN' THEN
3530: -- Set the Balance Context
3531: pay_balance_pkg.set_context('tax_unit_id', g_gre_org_id);
3532: pay_balance_pkg.set_context('date_earned', g_action_effective_date);
3533: IF g_debug THEN
3534: hr_utility.set_location(' tax_unit_id: '||g_gre_org_id, 5);
3535: hr_utility.set_location(' date_earned: '||g_action_effective_date, 5);
3536: END IF;

Line 3544: l_balance_amount := pay_balance_pkg.get_value

3540: --
3541: IF g_extract_params(i).reporting_dimension = 'ASG_RUN' THEN
3542: --Get the balance amount
3543: IF l_defined_balance_id IS NOT NULL THEN
3544: l_balance_amount := pay_balance_pkg.get_value
3545: (p_defined_balance_id => l_defined_balance_id,
3546: p_assignment_action_id => g_asg_action_id );
3547: l_bal_total_amt := l_bal_total_amt + NVL(l_balance_amount,0);
3548: END IF;

Line 3570: pay_balance_pkg.set_context('tax_unit_id', asgact_rec.tax_unit_id);

3566: )
3567: LOOP
3568: IF g_legislation_code = 'MX' THEN
3569: -- Set the Balance Context
3570: pay_balance_pkg.set_context('tax_unit_id', asgact_rec.tax_unit_id);
3571: pay_balance_pkg.set_context('date_earned', asgact_rec.effective_date);
3572: IF g_debug THEN
3573: hr_utility.set_location(' tax_unit_id: '||asgact_rec.tax_unit_id, 5);
3574: hr_utility.set_location(' date_earned: '||asgact_rec.effective_date, 5);

Line 3571: pay_balance_pkg.set_context('date_earned', asgact_rec.effective_date);

3567: LOOP
3568: IF g_legislation_code = 'MX' THEN
3569: -- Set the Balance Context
3570: pay_balance_pkg.set_context('tax_unit_id', asgact_rec.tax_unit_id);
3571: pay_balance_pkg.set_context('date_earned', asgact_rec.effective_date);
3572: IF g_debug THEN
3573: hr_utility.set_location(' tax_unit_id: '||asgact_rec.tax_unit_id, 5);
3574: hr_utility.set_location(' date_earned: '||asgact_rec.effective_date, 5);
3575: END IF;

Line 3581: pay_balance_pkg.get_value

3577: IF g_legislation_code = 'MX' AND
3578: g_gre_org_id IS NOT NULL AND
3579: asgact_rec.tax_unit_id = g_gre_org_id THEN
3580: l_balance_amount :=
3581: pay_balance_pkg.get_value
3582: (p_defined_balance_id => l_defined_balance_id,
3583: p_assignment_action_id => asgact_rec.assignment_action_id );
3584:
3585: ELSIF g_legislation_code <> 'MX' THEN

Line 3588: pay_balance_pkg.get_value

3584:
3585: ELSIF g_legislation_code <> 'MX' THEN
3586:
3587: l_balance_amount :=
3588: pay_balance_pkg.get_value
3589: (p_defined_balance_id => l_defined_balance_id,
3590: p_assignment_action_id => asgact_rec.assignment_action_id );
3591: END IF;
3592: