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

Line 335: fnd_date.canonical_to_date('''||

331: AND ppa_arch.report_category = ''ARCHIVE''
332: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
333: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
334: AND TRUNC(ppa_arch.effective_date,''Y'') =
335: fnd_date.canonical_to_date('''||
336: fnd_date.date_to_canonical(gd_effective_date)||''')
337: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
338: AND paa_arch.action_status = ''C''
339: AND :p_payroll_action_id = '||p_payroll_action_id||'

Line 336: fnd_date.date_to_canonical(gd_effective_date)||''')

332: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
333: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
334: AND TRUNC(ppa_arch.effective_date,''Y'') =
335: fnd_date.canonical_to_date('''||
336: fnd_date.date_to_canonical(gd_effective_date)||''')
337: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
338: AND paa_arch.action_status = ''C''
339: AND :p_payroll_action_id = '||p_payroll_action_id||'
340: ORDER BY 1';

Line 558: ,to_char(fnd_date.canonical_to_date(start_month),'mm') START_MONTH

554: PROCEDURE generate_xml AS
555:
556: CURSOR c_dim_rec (cp_assignment_action_id number,p_format varchar2) IS
557: SELECT dim.person_id PERSON_ID
558: ,to_char(fnd_date.canonical_to_date(start_month),'mm') START_MONTH
559: ,to_char(fnd_date.canonical_to_date(end_month),'mm') END_MONTH
560: ,replace(RFC_ID,'-','') RFC_ID
561: ,CURP
562: ,ltrim(rtrim(PATERNAL_LAST_NAME)) PATERNAL_LAST_NAME

Line 559: ,to_char(fnd_date.canonical_to_date(end_month),'mm') END_MONTH

555:
556: CURSOR c_dim_rec (cp_assignment_action_id number,p_format varchar2) IS
557: SELECT dim.person_id PERSON_ID
558: ,to_char(fnd_date.canonical_to_date(start_month),'mm') START_MONTH
559: ,to_char(fnd_date.canonical_to_date(end_month),'mm') END_MONTH
560: ,replace(RFC_ID,'-','') RFC_ID
561: ,CURP
562: ,ltrim(rtrim(PATERNAL_LAST_NAME)) PATERNAL_LAST_NAME
563: ,ltrim(rtrim(MATERNAL_LAST_NAME)) MATERNAL_LAST_NAME