APPS.PAY_MX_FORMAT_2D dependencies on FND_DATE

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

319: AND ppa_arch.report_category = ''ARCHIVE''
320: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
321: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
322: AND TRUNC(ppa_arch.effective_date,''Y'') =
323: fnd_date.canonical_to_date('''||
324: fnd_date.date_to_canonical(gd_effective_date)||''')
325: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
326: AND paa_arch.action_status = ''C''
327: AND :p_payroll_action_id = '||p_payroll_action_id||'

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

320: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
321: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
322: AND TRUNC(ppa_arch.effective_date,''Y'') =
323: fnd_date.canonical_to_date('''||
324: fnd_date.date_to_canonical(gd_effective_date)||''')
325: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
326: AND paa_arch.action_status = ''C''
327: AND :p_payroll_action_id = '||p_payroll_action_id||'
328: ORDER BY serial_number';

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

543: PROCEDURE generate_xml AS
544:
545: CURSOR c_format2d_rec (cp_assignment_action_id number) IS
546: SELECT format2d.person_id PERSON_ID
547: ,to_char(fnd_date.canonical_to_date(start_month),'mm') START_MONTH
548: ,to_char(fnd_date.canonical_to_date(end_month),'mm') END_MONTH
549: ,replace(ER_RFC_ID,'-','') ER_RFC_ID
550: ,CURP
551: ,ltrim(rtrim(PATERNAL_LAST_NAME)) PATERNAL_LAST_NAME

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

544:
545: CURSOR c_format2d_rec (cp_assignment_action_id number) IS
546: SELECT format2d.person_id PERSON_ID
547: ,to_char(fnd_date.canonical_to_date(start_month),'mm') START_MONTH
548: ,to_char(fnd_date.canonical_to_date(end_month),'mm') END_MONTH
549: ,replace(ER_RFC_ID,'-','') ER_RFC_ID
550: ,CURP
551: ,ltrim(rtrim(PATERNAL_LAST_NAME)) PATERNAL_LAST_NAME
552: ,ltrim(rtrim(MATERNAL_LAST_NAME)) MATERNAL_LAST_NAME

Line 558: ,(fnd_date.canonical_to_date(end_month) -

554: ,ltrim(rtrim(PATERNAL_LAST_NAME))||' '||
555: ltrim(rtrim(MATERNAL_LAST_NAME))||' '||
556: ltrim(rtrim(NAMES)) NAME
557: ,0 WAGE_LEVEL
558: ,(fnd_date.canonical_to_date(end_month) -
559: fnd_date.canonical_to_date(start_month)) + 1 TOTAL_DAYS_WORKED
560: ,(ISR_SUBJECT_FOR_FIXED_EARNINGS +
561: ISR_EXEMPT_FOR_FIXED_EARNINGS) SAL_WAGES
562: ,nvl(ISR_SUBJECT_FOR_OVERTIME,0) +

Line 559: fnd_date.canonical_to_date(start_month)) + 1 TOTAL_DAYS_WORKED

555: ltrim(rtrim(MATERNAL_LAST_NAME))||' '||
556: ltrim(rtrim(NAMES)) NAME
557: ,0 WAGE_LEVEL
558: ,(fnd_date.canonical_to_date(end_month) -
559: fnd_date.canonical_to_date(start_month)) + 1 TOTAL_DAYS_WORKED
560: ,(ISR_SUBJECT_FOR_FIXED_EARNINGS +
561: ISR_EXEMPT_FOR_FIXED_EARNINGS) SAL_WAGES
562: ,nvl(ISR_SUBJECT_FOR_OVERTIME,0) +
563: nvl(ISR_EXEMPT_FOR_OVERTIME,0) OVERTIME