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

Line 361: select to_char(fnd_date.canonical_to_date(max(ni.global_value)),'YYYY')

357: l_ni_tax_year varchar2(4); -- EOY 2011/12
358: --
359: -- Cursor definitions
360: CURSOR C_NI_NEW_TAX_YEAR is
361: select to_char(fnd_date.canonical_to_date(max(ni.global_value)),'YYYY')
362: from ff_globals_f ni
363: where ni.global_name = 'NI_NEW_TAX_YEAR'
364: and ni.business_group_id is null
365: and ni.legislation_code = 'GB';

Line 416: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')

412: SUBSTR(ltrim(rtrim(fai2.value)),1,35))), ' ') FIRST_NAME
413: ,nvl(max(decode(fue2.user_entity_name,'X_MIDDLE_NAME', SUBSTR(ltrim(rtrim(fai2.value)),1,35))), ' ')
414: ,nvl(max(decode(fue2.user_entity_name,'X_TITLE', SUBSTR(ltrim(rtrim(fai2.value)),1,35))), ' ')
415: ,nvl(max(decode(fue2.user_entity_name,'X_DATE_OF_BIRTH',
416: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')
417: ,nvl(max(decode(fue2.user_entity_name,'X_SEX', substr(UPPER(fai2.value),1,1))),' ')
418: ,nvl(ltrim(max(decode(fue2.user_entity_name,'X_ADDRESS_LINE1',
419: decode(fai2.value,'','',rpad(fai2.value,35))))), ' ')
420: ,nvl(ltrim(max(decode(fue2.user_entity_name,'X_ADDRESS_LINE2',

Line 458: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')

454: ,nvl(max(decode(fue2.user_entity_name,'X_PREVIOUS_TAXABLE_PAY',
455: to_number(fai2.value))),0) previous_taxable
456: ,nvl(max(decode(fue2.user_entity_name,'X_PREVIOUS_TAX_PAID', to_number(fai2.value))),0)
457: ,nvl(max(decode(fue2.user_entity_name,'X_START_OF_EMP',
458: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')
459: ,max(decode(fue2.user_entity_name,'X_TERMINATION_DATE',
460: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY')))
461: ,nvl(max(decode(fue2.user_entity_name,'X_WIDOWS_AND_ORPHANS',
462: ROUND(to_number(fai2.value)/100))),0)

Line 460: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY')))

456: ,nvl(max(decode(fue2.user_entity_name,'X_PREVIOUS_TAX_PAID', to_number(fai2.value))),0)
457: ,nvl(max(decode(fue2.user_entity_name,'X_START_OF_EMP',
458: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')
459: ,max(decode(fue2.user_entity_name,'X_TERMINATION_DATE',
460: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY')))
461: ,nvl(max(decode(fue2.user_entity_name,'X_WIDOWS_AND_ORPHANS',
462: ROUND(to_number(fai2.value)/100))),0)
463: ,nvl(max(decode(fue2.user_entity_name,'X_STUDENT_LOANS', trunc(fai2.value/100))),0) student_loans
464: ,nvl(max(decode(fue2.user_entity_name,'X_WEEK_53_INDICATOR',

Line 475: fnd_date.canonical_to_date(fai2.value)))

471: ,nvl(max(decode(fue2.user_entity_name,'X_DIRECTOR_INDICATOR',
472: substr(UPPER(fai2.value),1,1))),' ')
473: ,act.assignment_id
474: ,max(decode(fue2.user_entity_name,'X_EFFECTIVE_END_DATE',
475: fnd_date.canonical_to_date(fai2.value)))
476: ,nvl(max(decode(fue2.user_entity_name,'X_ASSIGNMENT_MESSAGE',
477: SUBSTR(fai2.VALUE, 1,60))),' ')
478: ,nvl(max(decode(fue2.user_entity_name,'X_MULTIPLE_ASG_FLAG',
479: SUBSTR(fai2.VALUE, 1,1))),' ')

Line 1636: fnd_Date.date_to_displaydate(g_start_year));

1632: OPEN get_start_end_year(g_payroll_action_id);
1633: FETCH get_start_end_year INTO g_start_year, g_end_year;
1634: CLOSE get_start_end_year;
1635: hr_utility.trace('After get_start_end_year, g_start_year='||
1636: fnd_Date.date_to_displaydate(g_start_year));
1637: hr_utility.trace('g_end_year='||
1638: fnd_Date.date_to_displaydate(g_end_year));
1639: --
1640: hr_utility.set_location('pay_gb_eoy_magtape.eoy_control',25);

Line 1638: fnd_Date.date_to_displaydate(g_end_year));

1634: CLOSE get_start_end_year;
1635: hr_utility.trace('After get_start_end_year, g_start_year='||
1636: fnd_Date.date_to_displaydate(g_start_year));
1637: hr_utility.trace('g_end_year='||
1638: fnd_Date.date_to_displaydate(g_end_year));
1639: --
1640: hr_utility.set_location('pay_gb_eoy_magtape.eoy_control',25);
1641: --
1642: -- Check to see if the Payroll Action just retrieved has any

Line 3217: hr_utility.trace('p_effective_date ='|| fnd_date.date_to_displaydate(p_effective_date));

3213: --
3214: -- hr_utility.trace_on(null, 'RMEOYVTC');
3215: hr_utility.trace('Entering pay_gb_eoy_magtape.validate_tax_code.');
3216: hr_utility.trace('p_tax_code = '|| p_tax_code);
3217: hr_utility.trace('p_effective_date ='|| fnd_date.date_to_displaydate(p_effective_date));
3218: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3219: l_return_value := hr_gb_utility.tax_code_validate(p_tax_code => p_tax_code,
3220: p_effective_date => p_effective_date,
3221: p_assignment_id => p_assignment_id);