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 2043: fnd_date.date_to_canonical(p_date_earned));

2039: hr_utility_trace('p_business_group_id: '||p_business_group_id);
2040: hr_utility_trace('p_assignment_id: '||p_assignment_id);
2041: hr_utility_trace('p_tax_unit_id: '||p_tax_unit_id);
2042: hr_utility_trace('p_date_earned: '||
2043: fnd_date.date_to_canonical(p_date_earned));
2044: hr_utility_trace('p_calc_mode: '||p_calc_mode);
2045: hr_utility_trace('p_subject_amount: '||p_subject_amount);
2046: hr_utility_trace('p_isr_rates_table: '||p_isr_rates_table);
2047: hr_utility_trace('p_subsidy_table: '||p_subsidy_table);

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

2136: hr_utility_trace('Actual worked days in the period for ISR Tax '||to_char(ln_worked_days));
2137: hr_utility_trace('worked days for proration in the period for ISR Tax '||to_char(ln_le_worked_days));
2138: --End of Bug Fix 6852627
2139: IF to_char(l_date_paid,'yyyymmdd')
2140: >= to_char(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') AND P_CALC_MODE = 'ARTICLE113' THEN
2141: hr_utility_trace('ISr Proration in 2008');
2142: 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
2143:
2144: ln_ISR_proj_subject := ROUND(((ln_ISR_proj_subject * ln_le_days_month) / ln_le_worked_days),2);

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

2184:
2185: hr_utility_trace('p_isr_calculated: '||p_isr_calculated);
2186:
2187: IF TO_CHAR(l_date_paid,'yyyymmdd')
2188: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2189:
2190: /* Subsidy Calculation */
2191: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2192: p_business_group_id

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

2278:
2279: P_CREDIT_TO_SALARY := nvl(P_CREDIT_TO_SALARY,0);
2280:
2281: IF TO_CHAR(l_date_paid,'yyyymmdd')
2282: >= TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2283:
2284: /*bug#8932102:
2285: 1. Seperated ld_hire_date from cursor csr_get_payroll_id
2286: and created seperate cursor to fetch ld_hire_date, this is because

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

2528:
2529: /*Incuded the proration logic based on balance ISR Non working days*/
2530: --Start of Bug fix 6852627
2531: IF to_char(l_date_paid,'yyyymmdd')
2532: >= to_char(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') AND P_CALC_MODE = 'ARTICLE113' THEN
2533: 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
2534:
2535: hr_utility_trace('-- Non workings days are feeded, need to proproate ISR Tax --');
2536:

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

2568: p_credit_to_salary_paid := 0;
2569: END IF;
2570: /*To feed ISR Subject Adjusted Balance*/
2571: IF TO_CHAR(l_date_paid,'yyyymmdd')
2572: >= TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2573: p_isr_creditable_subsidy := ln_ISR_proj_subject;
2574: hr_utility_trace(' Feeding ISR Subject Adjusted Balance value in 2008 = p_isr_creditable_subsidy'||p_isr_creditable_subsidy);
2575: END IF;
2576: hr_utility_trace('p_credit_to_salary_paid: '||p_credit_to_salary_paid);

Line 2882: fnd_date.date_to_canonical(p_date_earned));

2878: hr_utility_trace('p_business_group_id: '||p_business_group_id);
2879: hr_utility_trace('p_assignment_id: '||p_assignment_id);
2880: hr_utility_trace('p_tax_unit_id: '||p_tax_unit_id);
2881: hr_utility_trace('p_date_earned: '||
2882: fnd_date.date_to_canonical(p_date_earned));
2883: hr_utility_trace('p_run_type: '||p_run_type);
2884: hr_utility_trace('p_calc_mode: '||p_calc_mode);
2885: hr_utility_trace('p_subject_amount: '||p_subject_amount);
2886: hr_utility_trace('p_isr_rates_table: '||p_isr_rates_table);

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

2968: hr_utility_trace('Actual worked days in the period for ISR Tax '||to_char(ln_worked_days));
2969: hr_utility_trace('worked days for proration in the period for ISR Tax '||to_char(ln_le_worked_days));
2970: --End of Bug Fix 6852627
2971: IF to_char(l_date_paid,'yyyymmdd')
2972: >= to_char(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') AND P_CALC_MODE = 'ARTICLE113' THEN
2973: hr_utility_trace('ISr Proration in 2008');
2974: 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
2975:
2976: ln_ISR_proj_subject := ROUND(((ln_ISR_proj_subject * ln_le_days_month) / ln_le_worked_days),2);

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

3016:
3017: hr_utility_trace('p_isr_calculated: '||p_isr_calculated);
3018:
3019: IF TO_CHAR(l_date_paid,'yyyymmdd')
3020: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
3021:
3022: /* Subsidy Calculation */
3023: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3024: p_business_group_id

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

3110:
3111: P_CREDIT_TO_SALARY := nvl(P_CREDIT_TO_SALARY,0);
3112:
3113: IF TO_CHAR(l_date_paid,'yyyymmdd')
3114: >= TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
3115:
3116: OPEN csr_get_payroll_id; /*bug#8932102 */
3117: FETCH csr_get_payroll_id INTO ln_payroll_id;
3118: CLOSE csr_get_payroll_id;

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

3351:
3352: /*Incuded the proration logic based on balance ISR Non working days*/
3353: --Start of Bug fix 6852627
3354: IF to_char(l_date_paid,'yyyymmdd')
3355: >= to_char(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') AND P_CALC_MODE = 'ARTICLE113' THEN
3356: 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
3357:
3358: hr_utility_trace('-- Non workings days are feeded, need to proproate ISR Tax --');
3359:

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

3395: p_credit_to_salary_paid := 0;
3396: END IF;
3397: /*To feed ISR Subject Adjusted Balance*/
3398: IF TO_CHAR(l_date_paid,'yyyymmdd')
3399: >= TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
3400: p_isr_creditable_subsidy := ln_ISR_proj_subject;
3401: hr_utility_trace(' Feeding ISR Subject Adjusted Balance value in 2008 = p_isr_creditable_subsidy'||p_isr_creditable_subsidy);
3402: END IF;
3403: IF p_run_type = 'ADJTAX' OR p_run_type = 'MTDTAXADJ' THEN

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

3916: P_CTX_DATE_EARNED DATE
3917: ) RETURN VARCHAR2 AS
3918:
3919: CURSOR csr_get_dates IS
3920: SELECT fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
3921: ||'/'||hoi.org_information7),
3922: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
3923: ||'/'||hoi.org_information8),
3924: paf.person_id

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

3918:
3919: CURSOR csr_get_dates IS
3920: SELECT fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
3921: ||'/'||hoi.org_information7),
3922: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
3923: ||'/'||hoi.org_information8),
3924: paf.person_id
3925: FROM hr_organization_information hoi
3926: ,per_assignments_f paf

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

3948:
3949: CURSOR c_get_hire_date ( cp_person_id NUMBER
3950: ,cp_effective_date DATE ) IS
3951: SELECT MAX (pps.date_start), MAX(nvl(actual_termination_date,
3952: fnd_date.canonical_to_date('4712/12/31')))
3953: FROM per_periods_of_service pps
3954: WHERE pps.person_id = cp_person_id
3955: AND pps.date_start <= cp_effective_date;
3956: --bug 7604298

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

4120: SELECT pei_information1
4121: FROM per_people_extra_info
4122: WHERE person_id = p_person_id
4123: AND information_type='MX_EMP_TAX_SIGNUP'
4124: AND P_CTX_DATE_EARNED BETWEEN fnd_date.canonical_to_date(pei_information2)
4125: AND fnd_date.canonical_to_date(pei_information3);
4126:
4127: l_flag VARCHAR2(4);
4128: l_person_id per_all_people_f.person_id%TYPE;

Line 4125: AND fnd_date.canonical_to_date(pei_information3);

4121: FROM per_people_extra_info
4122: WHERE person_id = p_person_id
4123: AND information_type='MX_EMP_TAX_SIGNUP'
4124: AND P_CTX_DATE_EARNED BETWEEN fnd_date.canonical_to_date(pei_information2)
4125: AND fnd_date.canonical_to_date(pei_information3);
4126:
4127: l_flag VARCHAR2(4);
4128: l_person_id per_all_people_f.person_id%TYPE;
4129: l_exempt_adj per_people_extra_info.pei_information1%TYPE;