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 329: fnd_date.canonical_to_date('''||

325: AND ppa_arch.report_category = ''ARCHIVE''
326: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
327: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
328: AND TRUNC(ppa_arch.effective_date,''Y'') =
329: fnd_date.canonical_to_date('''||
330: fnd_date.date_to_canonical(gd_effective_date)||''')
331: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
332: AND paa_arch.action_status = ''C''
333: AND :p_payroll_action_id = '||p_payroll_action_id||'

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

326: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
327: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
328: AND TRUNC(ppa_arch.effective_date,''Y'') =
329: fnd_date.canonical_to_date('''||
330: fnd_date.date_to_canonical(gd_effective_date)||''')
331: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
332: AND paa_arch.action_status = ''C''
333: AND :p_payroll_action_id = '||p_payroll_action_id||'
334: ORDER BY 1';

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

548: PROCEDURE generate_xml AS
549:
550: CURSOR c_dim_rec (cp_assignment_action_id number,p_format varchar2) IS
551: SELECT dim.person_id PERSON_ID
552: ,to_char(fnd_date.canonical_to_date(start_month),'mm') START_MONTH
553: ,to_char(fnd_date.canonical_to_date(end_month),'mm') END_MONTH
554: ,replace(RFC_ID,'-','') RFC_ID
555: ,CURP
556: ,ltrim(rtrim(PATERNAL_LAST_NAME)) PATERNAL_LAST_NAME

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

549:
550: CURSOR c_dim_rec (cp_assignment_action_id number,p_format varchar2) IS
551: SELECT dim.person_id PERSON_ID
552: ,to_char(fnd_date.canonical_to_date(start_month),'mm') START_MONTH
553: ,to_char(fnd_date.canonical_to_date(end_month),'mm') END_MONTH
554: ,replace(RFC_ID,'-','') RFC_ID
555: ,CURP
556: ,ltrim(rtrim(PATERNAL_LAST_NAME)) PATERNAL_LAST_NAME
557: ,ltrim(rtrim(MATERNAL_LAST_NAME)) MATERNAL_LAST_NAME