APPS.OTA_FR_TRG_SUM dependencies on FND_NUMBER

Line 335: fnd_number.canonical_to_number(pcf.ctr_information11)

331: case
332: when pcf.ctr_information11 is null then
333: paaf.normal_hours
334: else
335: fnd_number.canonical_to_number(pcf.ctr_information11)
336: end CONT_WRK_HRS,---CONTRACTUAL_WORKING_HOURS --It is the hours in the DDF segment with unit ,display unit also
337: case
338: when pcf.ctr_information11 is null then
339: OTA_FR_TRG_SUM.get_lookup_value('FREQUENCY',paaf.frequency)

Line 420: fnd_number.canonical_to_number(otpc.tp_cost_information4) C_W_O_HR , --Hours Outside working

416: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
417: when 'COMP_DEV' then
418: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
419: end) C_W_L_CAT,--Legal category
420: fnd_number.canonical_to_number(otpc.tp_cost_information4) C_W_O_HR , --Hours Outside working
421: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',nvl(otpc.amount,0),
422: nvl(fnd_number.canonical_to_number(otpc.tp_cost_information3),0))C_W_TOT_HR --Total Hours
423: from per_all_people_f papf,
424: ota_delegate_bookings odb,

Line 422: nvl(fnd_number.canonical_to_number(otpc.tp_cost_information3),0))C_W_TOT_HR --Total Hours

418: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',otpc.tp_cost_information3)
419: end) C_W_L_CAT,--Legal category
420: fnd_number.canonical_to_number(otpc.tp_cost_information4) C_W_O_HR , --Hours Outside working
421: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',nvl(otpc.amount,0),
422: nvl(fnd_number.canonical_to_number(otpc.tp_cost_information3),0))C_W_TOT_HR --Total Hours
423: from per_all_people_f papf,
424: ota_delegate_bookings odb,
425: ota_booking_status_types obst,
426: ota_events oevent,

Line 449: fnd_number.canonical_to_number(nvl(otpc.tp_cost_information3,0)))) W_TOT_HOURS ,

445:
446:
447: cursor c_emp_w_trg_tot is
448: select sum(decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',otpc.amount,
449: fnd_number.canonical_to_number(nvl(otpc.tp_cost_information3,0)))) W_TOT_HOURS ,
450: sum(fnd_number.canonical_to_number(nvl(otpc.tp_cost_information4,0))) W_TOT_OUT_WK_HR,
451: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',
452: otpc.tp_cost_information3,
453: ' ') LEGAL_CATG --i)JOB_ADAPT ii) JOB_EVOL , iii)COMP_DEV

Line 450: sum(fnd_number.canonical_to_number(nvl(otpc.tp_cost_information4,0))) W_TOT_OUT_WK_HR,

446:
447: cursor c_emp_w_trg_tot is
448: select sum(decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',otpc.amount,
449: fnd_number.canonical_to_number(nvl(otpc.tp_cost_information3,0)))) W_TOT_HOURS ,
450: sum(fnd_number.canonical_to_number(nvl(otpc.tp_cost_information4,0))) W_TOT_OUT_WK_HR,
451: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',
452: otpc.tp_cost_information3,
453: ' ') LEGAL_CATG --i)JOB_ADAPT ii) JOB_EVOL , iii)COMP_DEV
454: from per_all_people_f papf,

Line 478: fnd_number.canonical_to_number(nvl(paa.ABSENCE_DAYS,0)) DURATION_DAYS, --Duration days

474: cursor c_emp_o_trg is /* Cursor for Outside Training plan*/
475: select distinct paat.name ABS_TYPE,-- Absence Type
476: to_char(paa.DATE_START,'YYYY-MM-DD') C_O_S_DAT, --Start Date
477: to_char(paa.DATE_END,'YYYY-MM-DD') C_O_E_DAT, --End date
478: fnd_number.canonical_to_number(nvl(paa.ABSENCE_DAYS,0)) DURATION_DAYS, --Duration days
479: fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0)) C_O_TOT_HR, --Duration hours
480: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_LEAVE_CATEGORY',paa.ABS_INFORMATION1) TRG_LEAV_CATG,-- Training Leave Category
481: paa.ABS_INFORMATION2 C_O_NAME, --Course
482: pv.VENDOR_NAME TRG_PROV,--Training Provider

Line 479: fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0)) C_O_TOT_HR, --Duration hours

475: select distinct paat.name ABS_TYPE,-- Absence Type
476: to_char(paa.DATE_START,'YYYY-MM-DD') C_O_S_DAT, --Start Date
477: to_char(paa.DATE_END,'YYYY-MM-DD') C_O_E_DAT, --End date
478: fnd_number.canonical_to_number(nvl(paa.ABSENCE_DAYS,0)) DURATION_DAYS, --Duration days
479: fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0)) C_O_TOT_HR, --Duration hours
480: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_LEAVE_CATEGORY',paa.ABS_INFORMATION1) TRG_LEAV_CATG,-- Training Leave Category
481: paa.ABS_INFORMATION2 C_O_NAME, --Course
482: pv.VENDOR_NAME TRG_PROV,--Training Provider
483: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_TYPE',paa.ABS_INFORMATION4) TYPE_OF_TRG, --Type Of Training

Line 494: fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0)) C_O_O_HR, --Hours Outside Working Hours

490: 'II-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
491: when 'COMP_DEV' then
492: 'III-'||OTA_FR_TRG_SUM.get_lookup_value('FR_LEGAL_TRG_CATG',paa.ABS_INFORMATION19)
493: end C_O_L_CAT, ---Legal Category
494: fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0)) C_O_O_HR, --Hours Outside Working Hours
495: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_SUBSIDY_TYPE',paa.ABS_INFORMATION5) SUBSI_TYPE, --Subsidized Type
496: hfov.name SUBSI_ORG --Subsidizing Organization
497: from per_all_people_f papf,
498: per_absence_attendances paa,

Line 519: Select sum(fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0))) O_TOT_HOURS ,

515: order by C_O_S_DAT asc;
516:
517:
518: cursor c_emp_o_trg_tot is
519: Select sum(fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0))) O_TOT_HOURS ,
520: sum(fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0))) O_TOT_OUT_WK_HR,
521: (paa.ABS_INFORMATION19) LEGAL_CATG --i)JOB_ADAPT ii) JOB_EVOL , iii)COMP_DEV
522: from per_all_people_f papf,
523: per_absence_attendances paa

Line 520: sum(fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0))) O_TOT_OUT_WK_HR,

516:
517:
518: cursor c_emp_o_trg_tot is
519: Select sum(fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0))) O_TOT_HOURS ,
520: sum(fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0))) O_TOT_OUT_WK_HR,
521: (paa.ABS_INFORMATION19) LEGAL_CATG --i)JOB_ADAPT ii) JOB_EVOL , iii)COMP_DEV
522: from per_all_people_f papf,
523: per_absence_attendances paa
524: where papf.person_id=l_p_person_id