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 373: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')

369: SUBSTR(ltrim(rtrim(fai2.value)),1,35))), ' ') FIRST_NAME
370: ,nvl(max(decode(fue2.user_entity_name,'X_MIDDLE_NAME', SUBSTR(ltrim(rtrim(fai2.value)),1,35))), ' ')
371: ,nvl(max(decode(fue2.user_entity_name,'X_TITLE', SUBSTR(ltrim(rtrim(fai2.value)),1,35))), ' ')
372: ,nvl(max(decode(fue2.user_entity_name,'X_DATE_OF_BIRTH',
373: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')
374: ,nvl(max(decode(fue2.user_entity_name,'X_SEX', substr(UPPER(fai2.value),1,1))),' ')
375: ,nvl(ltrim(max(decode(fue2.user_entity_name,'X_ADDRESS_LINE1',
376: decode(fai2.value,'','',rpad(fai2.value,35))))), ' ')
377: ,nvl(ltrim(max(decode(fue2.user_entity_name,'X_ADDRESS_LINE2',

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

409: ,nvl(max(decode(fue2.user_entity_name,'X_PREVIOUS_TAXABLE_PAY',
410: to_number(fai2.value))),0) previous_taxable
411: ,nvl(max(decode(fue2.user_entity_name,'X_PREVIOUS_TAX_PAID', to_number(fai2.value))),0)
412: ,nvl(max(decode(fue2.user_entity_name,'X_START_OF_EMP',
413: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')
414: ,max(decode(fue2.user_entity_name,'X_TERMINATION_DATE',
415: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY')))
416: ,nvl(max(decode(fue2.user_entity_name,'X_WIDOWS_AND_ORPHANS',
417: ROUND(to_number(fai2.value)/100))),0)

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

411: ,nvl(max(decode(fue2.user_entity_name,'X_PREVIOUS_TAX_PAID', to_number(fai2.value))),0)
412: ,nvl(max(decode(fue2.user_entity_name,'X_START_OF_EMP',
413: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY'))),' ')
414: ,max(decode(fue2.user_entity_name,'X_TERMINATION_DATE',
415: TO_CHAR(fnd_date.canonical_to_date(fai2.value),'DDMMYYYY')))
416: ,nvl(max(decode(fue2.user_entity_name,'X_WIDOWS_AND_ORPHANS',
417: ROUND(to_number(fai2.value)/100))),0)
418: ,nvl(max(decode(fue2.user_entity_name,'X_STUDENT_LOANS', trunc(fai2.value/100))),0) student_loans
419: ,nvl(max(decode(fue2.user_entity_name,'X_WEEK_53_INDICATOR',

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

426: ,nvl(max(decode(fue2.user_entity_name,'X_DIRECTOR_INDICATOR',
427: substr(UPPER(fai2.value),1,1))),' ')
428: ,act.assignment_id
429: ,max(decode(fue2.user_entity_name,'X_EFFECTIVE_END_DATE',
430: fnd_date.canonical_to_date(fai2.value)))
431: ,nvl(max(decode(fue2.user_entity_name,'X_ASSIGNMENT_MESSAGE',
432: SUBSTR(fai2.VALUE, 1,60))),' ')
433: ,nvl(max(decode(fue2.user_entity_name,'X_MULTIPLE_ASG_FLAG',
434: SUBSTR(fai2.VALUE, 1,1))),' ')

Line 1432: fnd_Date.date_to_displaydate(g_start_year));

1428: OPEN get_start_end_year(g_payroll_action_id);
1429: FETCH get_start_end_year INTO g_start_year, g_end_year;
1430: CLOSE get_start_end_year;
1431: hr_utility.trace('After get_start_end_year, g_start_year='||
1432: fnd_Date.date_to_displaydate(g_start_year));
1433: hr_utility.trace('g_end_year='||
1434: fnd_Date.date_to_displaydate(g_end_year));
1435: --
1436: hr_utility.set_location('pay_gb_eoy_magtape.eoy_control',25);

Line 1434: fnd_Date.date_to_displaydate(g_end_year));

1430: CLOSE get_start_end_year;
1431: hr_utility.trace('After get_start_end_year, g_start_year='||
1432: fnd_Date.date_to_displaydate(g_start_year));
1433: hr_utility.trace('g_end_year='||
1434: fnd_Date.date_to_displaydate(g_end_year));
1435: --
1436: hr_utility.set_location('pay_gb_eoy_magtape.eoy_control',25);
1437: --
1438: -- Check to see if the Payroll Action just retrieved has any

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

2913: --
2914: -- hr_utility.trace_on(null, 'RMEOYVTC');
2915: hr_utility.trace('Entering pay_gb_eoy_magtape.validate_tax_code.');
2916: hr_utility.trace('p_tax_code = '|| p_tax_code);
2917: hr_utility.trace('p_effective_date ='|| fnd_date.date_to_displaydate(p_effective_date));
2918: hr_utility.trace('p_assignment_id = '||p_assignment_id);
2919: l_return_value := hr_gb_utility.tax_code_validate(p_tax_code => p_tax_code,
2920: p_effective_date => p_effective_date,
2921: p_assignment_id => p_assignment_id);