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 FND_DATE

Line 2113: ,p_entry_value1 => fnd_date.date_to_chardate(p_calculation_date) -- Bug 3127638

2109: ,p_business_group_id => p_business_group_id
2110: ,p_element_entry_id => p_element_entry_id
2111: ,p_object_version_number => l_ovn
2112: ,p_input_value_id1 => l_iv_id
2113: ,p_entry_value1 => fnd_date.date_to_chardate(p_calculation_date) -- Bug 3127638
2114: ,p_effective_start_date => l_effective_start_date
2115: ,p_effective_end_date => l_effective_end_date
2116: ,p_update_warning => l_warning
2117: );

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 3928: l_actual_probation_end_date:= fnd_date.canonical_to_date(

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:
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'));

Line 3931: l_const_probation_end_date:= fnd_date.canonical_to_date(

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:
3934: l_defer_deductions := pay_balance_pkg.run_db_item('PER_EMPLOYER_INFO_CN_ORG_DEFER_DEDUCTIONS',p_business_group_id,'CN');
3935:

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 4789: AND p_date_paid BETWEEN fnd_date.canonical_to_date(hoi.org_information3)

4785: FROM hr_organization_information hoi
4786: WHERE hoi.org_information_context = 'PER_ENN_ANN_TAX_CN'
4787: AND hoi.org_information1 = p_tax_area
4788: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4789: AND p_date_paid BETWEEN fnd_date.canonical_to_date(hoi.org_information3)
4790: AND nvl(fnd_date.canonical_to_date(hoi.org_information4), to_date( '31/12/4712','DD/MM/YYYY'));
4791:
4792: BEGIN
4793:

Line 4790: AND nvl(fnd_date.canonical_to_date(hoi.org_information4), to_date( '31/12/4712','DD/MM/YYYY'));

4786: WHERE hoi.org_information_context = 'PER_ENN_ANN_TAX_CN'
4787: AND hoi.org_information1 = p_tax_area
4788: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4789: AND p_date_paid BETWEEN fnd_date.canonical_to_date(hoi.org_information3)
4790: AND nvl(fnd_date.canonical_to_date(hoi.org_information4), to_date( '31/12/4712','DD/MM/YYYY'));
4791:
4792: BEGIN
4793:
4794: l_tax_area := null;

Line 4813: IF p_date_paid NOT BETWEEN fnd_date.canonical_to_date(l_start_date)

4809: );
4810: FETCH get_rule_bg INTO l_calculate_tax;
4811: CLOSE get_rule_bg;
4812: ELSE
4813: IF p_date_paid NOT BETWEEN fnd_date.canonical_to_date(l_start_date)
4814: AND nvl(fnd_date.canonical_to_date(l_end_date), to_date( '31/12/4712','DD/MM/YYYY'))
4815: THEN
4816: l_calculate_tax := 'N';
4817: END IF;

Line 4814: AND nvl(fnd_date.canonical_to_date(l_end_date), to_date( '31/12/4712','DD/MM/YYYY'))

4810: FETCH get_rule_bg INTO l_calculate_tax;
4811: CLOSE get_rule_bg;
4812: ELSE
4813: IF p_date_paid NOT BETWEEN fnd_date.canonical_to_date(l_start_date)
4814: AND nvl(fnd_date.canonical_to_date(l_end_date), to_date( '31/12/4712','DD/MM/YYYY'))
4815: THEN
4816: l_calculate_tax := 'N';
4817: END IF;
4818: END IF;