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

Line 119: AND fnd_date.canonical_to_date(pev.screen_entry_value) BETWEEN p_start_date AND p_end_date

115: AND pet.element_type_id = piv.element_type_id
116: AND pev.input_value_id = piv.input_value_id
117: AND piv.name IN ('Payment From Date', 'Payment To Date')
118: AND pee.assignment_id = p_assignment_id
119: AND fnd_date.canonical_to_date(pev.screen_entry_value) BETWEEN p_start_date AND p_end_date
120: AND pet.element_name = 'FR_SICKNESS_CPAM_INFO'
121: AND pee.element_entry_id <> p_curr_entry_id;
122:
123: -- Get absences occuring on or within the payment dates (even overlapping)

Line 133: , fnd_date.canonical_to_date(decode(paa.abs_information1,NULL,paa.abs_information7,

129: , paa.date_end date_end
130: , (paa.date_end - paa.date_start + 1) duration
131: , nvl(decode(paa.abs_information1,NULL,paa.abs_information8,
132: paa_p.abs_information8),'N') pay_estimate
133: , fnd_date.canonical_to_date(decode(paa.abs_information1,NULL,paa.abs_information7,
134: paa_p.abs_information7)) ijss_ineligible_date
135: FROM per_absence_attendances paa,
136: per_absence_attendances paa_p,
137: per_all_people_f pap,