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

Line 2461: ,p_balance_value_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab

2457: (p_phf_si_type IN VARCHAR2
2458: ,p_assignment_action_id IN NUMBER
2459: ,p_tax_unit_id IN NUMBER
2460: ,p_date_earned IN DATE
2461: ,p_balance_value_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab
2462: )
2463: IS
2464:
2465: CURSOR c_element_name is

Line 2534: pay_balance_pkg.get_value

2530:
2531: FOR cnt in p_balance_value_tab.first .. p_balance_value_tab.last
2532: LOOP
2533: p_balance_value_tab(cnt).balance_value :=
2534: pay_balance_pkg.get_value
2535: (p_defined_balance_id => p_balance_value_tab(cnt).defined_balance_id
2536: ,p_assignment_action_id => p_assignment_action_id
2537: ,p_tax_unit_id => p_tax_unit_id
2538: ,p_jurisdiction_code => NULL

Line 3925: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

3921:
3922: --
3923: -- Step 1: Get the various DBIs
3924: --
3925: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3926: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
3927:
3928: l_actual_probation_end_date:= fnd_date.canonical_to_date(
3929: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));

Line 3926: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);

3922: --
3923: -- Step 1: Get the various DBIs
3924: --
3925: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3926: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
3927:
3928: l_actual_probation_end_date:= fnd_date.canonical_to_date(
3929: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));
3930:

Line 3929: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));

3925: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3926: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
3927:
3928: l_actual_probation_end_date:= fnd_date.canonical_to_date(
3929: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));
3930:
3931: l_const_probation_end_date:= fnd_date.canonical_to_date(
3932: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));
3933:

Line 3932: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));

3928: l_actual_probation_end_date:= fnd_date.canonical_to_date(
3929: pay_balance_pkg.run_db_item('CTR_CN_ACTUAL_PROBATION_END_DATE',p_business_group_id,'CN'));
3930:
3931: l_const_probation_end_date:= fnd_date.canonical_to_date(
3932: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));
3933:
3934: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');
3935:
3936: l_deduct_in_probation_expiry := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEDUCT_IN_PROBATION_EXPIRY',p_business_group_id,'CN');

Line 3934: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');

3930:
3931: l_const_probation_end_date:= fnd_date.canonical_to_date(
3932: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));
3933:
3934: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');
3935:
3936: l_deduct_in_probation_expiry := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEDUCT_IN_PROBATION_EXPIRY',p_business_group_id,'CN');
3937:
3938: l_message := get_phf_si_deferred_amounts

Line 3936: l_deduct_in_probation_expiry := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEDUCT_IN_PROBATION_EXPIRY',p_business_group_id,'CN');

3932: pay_balance_pkg.run_db_item('CTR_CN_CONST_PROBATION_END_DATE',p_business_group_id,'CN'));
3933:
3934: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');
3935:
3936: l_deduct_in_probation_expiry := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEDUCT_IN_PROBATION_EXPIRY',p_business_group_id,'CN');
3937:
3938: l_message := get_phf_si_deferred_amounts
3939: (p_pay_proc_period_end_date => p_pay_proc_period_end_date
3940: ,p_actual_probation_end_date => NVL(l_actual_probation_end_date,g_start_date)

Line 4614: l_phfsi_retro_earnings_pyear := pay_balance_pkg.get_value

4610: p_phf_si_earnings_pyear := 0;
4611: ELSE
4612: l_retro_phfsi_bal_id := get_def_bal_id('PHFSI Constituents for Retro Elements','_ASG_YTD');
4613: IF l_retro_phfsi_bal_id <> 0 THEN
4614: l_phfsi_retro_earnings_pyear := pay_balance_pkg.get_value
4615: (p_defined_balance_id => get_def_bal_id('PHFSI Constituents for Retro Elements','_ASG_YTD')
4616: ,p_assignment_action_id => l_asg_yr_action_id
4617: ,p_tax_unit_id => p_employer_id
4618: ,p_jurisdiction_code => NULL

Line 4630: /* call pay_balance_pkg and fetch the value of the PHF_SI_EARNINGS YTD dimension */

4626: l_phfsi_retro_earnings_pyear := 0;
4627: END IF;
4628: hr_utility.trace('PHFSI Constituents for Retro Elements' || l_phfsi_retro_earnings_pyear);
4629:
4630: /* call pay_balance_pkg and fetch the value of the PHF_SI_EARNINGS YTD dimension */
4631: l_phfsi_earnings_pyear := pay_balance_pkg.get_value
4632: (p_defined_balance_id => get_def_bal_id('PHF SI Earnings','_ASG_YTD')
4633: ,p_assignment_action_id => l_asg_yr_action_id
4634: ,p_tax_unit_id => p_employer_id

Line 4631: l_phfsi_earnings_pyear := pay_balance_pkg.get_value

4627: END IF;
4628: hr_utility.trace('PHFSI Constituents for Retro Elements' || l_phfsi_retro_earnings_pyear);
4629:
4630: /* call pay_balance_pkg and fetch the value of the PHF_SI_EARNINGS YTD dimension */
4631: l_phfsi_earnings_pyear := pay_balance_pkg.get_value
4632: (p_defined_balance_id => get_def_bal_id('PHF SI Earnings','_ASG_YTD')
4633: ,p_assignment_action_id => l_asg_yr_action_id
4634: ,p_tax_unit_id => p_employer_id
4635: ,p_jurisdiction_code => NULL

Line 4647: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_temp_date));

4643: hr_utility.trace('PHF/SI Earnings Prev Yr' || l_phfsi_earnings_pyear);
4644: p_phf_si_earnings_pyear := nvl(l_phfsi_earnings_pyear,0) + nvl(l_phfsi_retro_earnings_pyear,0);
4645: hr_utility.trace('Total PHF/SI Earnings Prev Yr' || p_phf_si_earnings_pyear);
4646:
4647: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_temp_date));
4648: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
4649: l_pay_runs_prev_yr := fnd_number.canonical_to_number(
4650: pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN'));
4651: hr_utility.trace('Payroll runs Prev Yr' || l_pay_runs_prev_yr);

Line 4648: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);

4644: p_phf_si_earnings_pyear := nvl(l_phfsi_earnings_pyear,0) + nvl(l_phfsi_retro_earnings_pyear,0);
4645: hr_utility.trace('Total PHF/SI Earnings Prev Yr' || p_phf_si_earnings_pyear);
4646:
4647: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_temp_date));
4648: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
4649: l_pay_runs_prev_yr := fnd_number.canonical_to_number(
4650: pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN'));
4651: hr_utility.trace('Payroll runs Prev Yr' || l_pay_runs_prev_yr);
4652: p_phf_si_earnings_pyear := p_phf_si_earnings_pyear / l_pay_runs_prev_yr ;

Line 4650: pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN'));

4646:
4647: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_temp_date));
4648: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
4649: l_pay_runs_prev_yr := fnd_number.canonical_to_number(
4650: pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN'));
4651: hr_utility.trace('Payroll runs Prev Yr' || l_pay_runs_prev_yr);
4652: p_phf_si_earnings_pyear := p_phf_si_earnings_pyear / l_pay_runs_prev_yr ;
4653: END IF;
4654:

Line 4659: /* call pay_balance_pkg and fetch the value of the PHF_SI_EARNINGS MTD dimension */

4655: IF l_asg_mth_action_id IS NULL THEN
4656: /* No latest assignment action exists for the target month */
4657: p_phf_si_earnings_pmth := 0;
4658: ELSE
4659: /* call pay_balance_pkg and fetch the value of the PHF_SI_EARNINGS MTD dimension */
4660: p_phf_si_earnings_pmth := pay_balance_pkg.get_value
4661: (p_defined_balance_id => get_def_bal_id('PHF SI Earnings','_ASG_MTD')
4662: ,p_assignment_action_id => l_asg_mth_action_id
4663: ,p_tax_unit_id => p_employer_id

Line 4660: p_phf_si_earnings_pmth := pay_balance_pkg.get_value

4656: /* No latest assignment action exists for the target month */
4657: p_phf_si_earnings_pmth := 0;
4658: ELSE
4659: /* call pay_balance_pkg and fetch the value of the PHF_SI_EARNINGS MTD dimension */
4660: p_phf_si_earnings_pmth := pay_balance_pkg.get_value
4661: (p_defined_balance_id => get_def_bal_id('PHF SI Earnings','_ASG_MTD')
4662: ,p_assignment_action_id => l_asg_mth_action_id
4663: ,p_tax_unit_id => p_employer_id
4664: ,p_jurisdiction_code => NULL