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_MX_TAX_FUNCTIONS dependencies on FND_DATE

Line 1890: fnd_date.date_to_canonical(p_date_earned));

1886: hr_utility_trace('p_business_group_id: '||p_business_group_id);
1887: hr_utility_trace('p_assignment_id: '||p_assignment_id);
1888: hr_utility_trace('p_tax_unit_id: '||p_tax_unit_id);
1889: hr_utility_trace('p_date_earned: '||
1890: fnd_date.date_to_canonical(p_date_earned));
1891: hr_utility_trace('p_calc_mode: '||p_calc_mode);
1892: hr_utility_trace('p_subject_amount: '||p_subject_amount);
1893: hr_utility_trace('p_isr_rates_table: '||p_isr_rates_table);
1894: hr_utility_trace('p_subsidy_table: '||p_subsidy_table);

Line 1972: >= to_char(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') AND P_CALC_MODE = 'ARTICLE113' THEN

1968: hr_utility_trace('Actual worked days in the period for ISR Tax '||to_char(ln_worked_days));
1969: hr_utility_trace('worked days for proration in the period for ISR Tax '||to_char(ln_le_worked_days));
1970: --End of Bug Fix 6852627
1971: IF to_char(l_date_paid,'yyyymmdd')
1972: >= to_char(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') AND P_CALC_MODE = 'ARTICLE113' THEN
1973: hr_utility_trace('ISr Proration in 2008');
1974: IF nvl(ln_bal_ISR_non_wrkd_days,0) > 0 AND nvl(ln_bal_ISR_non_wrkd_days,0) < ln_days_in_a_period THEN
1975:
1976: ln_ISR_proj_subject := ROUND(((ln_ISR_proj_subject * ln_le_days_month) / ln_le_worked_days),2);

Line 2020: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN

2016:
2017: hr_utility_trace('p_isr_calculated: '||p_isr_calculated);
2018:
2019: IF TO_CHAR(l_date_paid,'yyyymmdd')
2020: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2021:
2022: /* Subsidy Calculation */
2023: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2024: p_business_group_id

Line 2104: >= TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN

2100:
2101: P_CREDIT_TO_SALARY := nvl(P_CREDIT_TO_SALARY,0);
2102:
2103: IF TO_CHAR(l_date_paid,'yyyymmdd')
2104: >= TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2105:
2106: OPEN csr_get_payroll_id;
2107: FETCH csr_get_payroll_id INTO ln_payroll_id,ld_hire_date;
2108: CLOSE csr_get_payroll_id;

Line 2336: >= to_char(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') AND P_CALC_MODE = 'ARTICLE113' THEN

2332:
2333: /*Incuded the proration logic based on balance ISR Non working days*/
2334: --Start of Bug fix 6852627
2335: IF to_char(l_date_paid,'yyyymmdd')
2336: >= to_char(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') AND P_CALC_MODE = 'ARTICLE113' THEN
2337: IF nvl(ln_bal_ISR_non_wrkd_days,0) > 0 AND nvl(ln_bal_ISR_non_wrkd_days,0) < ln_days_in_a_period THEN
2338:
2339: hr_utility_trace('-- Non workings days are feeded, need to proproate ISR Tax --');
2340:

Line 2376: >= TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN

2372: p_credit_to_salary_paid := 0;
2373: END IF;
2374: /*To feed ISR Subject Adjusted Balance*/
2375: IF TO_CHAR(l_date_paid,'yyyymmdd')
2376: >= TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2377: p_isr_creditable_subsidy := ln_ISR_proj_subject;
2378: hr_utility_trace(' Feeding ISR Subject Adjusted Balance value in 2008 = p_isr_creditable_subsidy'||p_isr_creditable_subsidy);
2379: END IF;
2380: hr_utility_trace('p_credit_to_salary_paid: '||p_credit_to_salary_paid);

Line 2622: SELECT fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')

2618: P_CTX_DATE_EARNED DATE
2619: ) RETURN VARCHAR2 AS
2620:
2621: CURSOR csr_get_dates IS
2622: SELECT fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
2623: ||'/'||hoi.org_information7),
2624: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
2625: ||'/'||hoi.org_information8),
2626: paf.person_id

Line 2624: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')

2620:
2621: CURSOR csr_get_dates IS
2622: SELECT fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
2623: ||'/'||hoi.org_information7),
2624: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
2625: ||'/'||hoi.org_information8),
2626: paf.person_id
2627: FROM hr_organization_information hoi
2628: ,per_assignments_f paf

Line 2654: fnd_date.canonical_to_date('4712/12/31')))

2650:
2651: CURSOR c_get_hire_date ( cp_person_id NUMBER
2652: ,cp_effective_date DATE ) IS
2653: SELECT MAX (pps.date_start), MAX(nvl(actual_termination_date,
2654: fnd_date.canonical_to_date('4712/12/31')))
2655: FROM per_periods_of_service pps
2656: WHERE pps.person_id = cp_person_id
2657: AND pps.date_start <= cp_effective_date;
2658: --bug 7604298

Line 2826: AND P_CTX_DATE_EARNED BETWEEN fnd_date.canonical_to_date(pei_information2)

2822: SELECT pei_information1
2823: FROM per_people_extra_info
2824: WHERE person_id = p_person_id
2825: AND information_type='MX_EMP_TAX_SIGNUP'
2826: AND P_CTX_DATE_EARNED BETWEEN fnd_date.canonical_to_date(pei_information2)
2827: AND fnd_date.canonical_to_date(pei_information3);
2828:
2829: l_flag VARCHAR2(4);
2830: l_person_id per_all_people_f.person_id%TYPE;

Line 2827: AND fnd_date.canonical_to_date(pei_information3);

2823: FROM per_people_extra_info
2824: WHERE person_id = p_person_id
2825: AND information_type='MX_EMP_TAX_SIGNUP'
2826: AND P_CTX_DATE_EARNED BETWEEN fnd_date.canonical_to_date(pei_information2)
2827: AND fnd_date.canonical_to_date(pei_information3);
2828:
2829: l_flag VARCHAR2(4);
2830: l_person_id per_all_people_f.person_id%TYPE;
2831: l_exempt_adj per_people_extra_info.pei_information1%TYPE;