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

Line 148: fnd_date.canonical_to_date(fai.value) between

144: pay_payroll_actions ppa,
145: pay_assignment_actions paa
146: where
147: fai.user_entity_id = ' || l_roe_date_uid || ' and
148: fnd_date.canonical_to_date(fai.value) between
149: ppa.start_date and
150: ppa.effective_date and
151: ppa.payroll_action_id = :p_pactid and
152: ppa.business_group_id = paf.business_group_id and

Line 155: fnd_date.canonical_to_date(fai.value) between

151: ppa.payroll_action_id = :p_pactid and
152: ppa.business_group_id = paf.business_group_id and
153: paa.assignment_action_id = fai.context1 and
154: paf.assignment_id = paa.assignment_id and
155: fnd_date.canonical_to_date(fai.value) between
156: paf.effective_start_date and
157: paf.effective_end_date and
158: person_id = '|| p_person_id;
159: elsif p_assignment_set is not null then

Line 168: fnd_date.canonical_to_date(fai.value) between

164: pay_assignment_actions paa,
165: HR_ASSIGNMENT_SET_AMENDMENTS haa
166: where
167: fai.user_entity_id = ' || l_roe_date_uid || ' and
168: fnd_date.canonical_to_date(fai.value) between
169: ppa.start_date and
170: ppa.effective_date and
171: ppa.payroll_action_id = :p_pactid and
172: ppa.business_group_id = paf.business_group_id and

Line 175: fnd_date.canonical_to_date(fai.value) between

171: ppa.payroll_action_id = :p_pactid and
172: ppa.business_group_id = paf.business_group_id and
173: paa.assignment_action_id = fai.context1 and
174: paf.assignment_id = paa.assignment_id and
175: fnd_date.canonical_to_date(fai.value) between
176: paf.effective_start_date and
177: paf.effective_end_date and
178: haa.assignment_id = paf.assignment_id and
179: haa.include_or_exclude = ''I'' and

Line 189: fnd_date.canonical_to_date(fai.value) between

185: pay_payroll_actions ppa,
186: pay_assignment_actions paa
187: where
188: fai.user_entity_id = ' || l_roe_date_uid || ' and
189: fnd_date.canonical_to_date(fai.value) between
190: ppa.start_date and
191: ppa.effective_date and
192: ppa.payroll_action_id = :p_pactid and
193: ppa.business_group_id = paf.business_group_id and

Line 196: fnd_date.canonical_to_date(fai.value) between

192: ppa.payroll_action_id = :p_pactid and
193: ppa.business_group_id = paf.business_group_id and
194: paa.assignment_action_id = fai.context1 and
195: paf.assignment_id = paa.assignment_id and
196: fnd_date.canonical_to_date(fai.value) between
197: paf.effective_start_date and
198: paf.effective_end_date';
199: end if;
200:

Line 280: fnd_date.canonical_to_date(fai1.value) between

276: ppa.report_qualifier = 'ROEQ' and
277: ppa.payroll_action_id = paa.payroll_action_id and
278: paa.assignment_action_id = fai1.context1 and
279: fai1.user_entity_id=l_roe_date_id and
280: fnd_date.canonical_to_date(fai1.value) between
281: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
282: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
283: fai1.context1 = fai2.context1 and
284: fai2.user_entity_id = l_roe_payroll_id and

Line 281: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and

277: ppa.payroll_action_id = paa.payroll_action_id and
278: paa.assignment_action_id = fai1.context1 and
279: fai1.user_entity_id=l_roe_date_id and
280: fnd_date.canonical_to_date(fai1.value) between
281: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
282: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
283: fai1.context1 = fai2.context1 and
284: fai2.user_entity_id = l_roe_payroll_id and
285: paa.assignment_id = paf.assignment_id and

Line 282: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and

278: paa.assignment_action_id = fai1.context1 and
279: fai1.user_entity_id=l_roe_date_id and
280: fnd_date.canonical_to_date(fai1.value) between
281: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
282: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
283: fai1.context1 = fai2.context1 and
284: fai2.user_entity_id = l_roe_payroll_id and
285: paa.assignment_id = paf.assignment_id and
286: fnd_date.canonical_to_date(fai1.value) between

Line 286: fnd_date.canonical_to_date(fai1.value) between

282: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
283: fai1.context1 = fai2.context1 and
284: fai2.user_entity_id = l_roe_payroll_id and
285: paa.assignment_id = paf.assignment_id and
286: fnd_date.canonical_to_date(fai1.value) between
287: paf.effective_start_date and
288: paf.effective_end_date and
289: paf.assignment_type = 'E' and
290: paf.person_id between

Line 313: fnd_date.canonical_to_date(fai1.value) between

309: ppa.report_qualifier = 'ROEQ' and
310: ppa.payroll_action_id = paa.payroll_action_id and
311: paa.assignment_action_id = fai1.context1 and
312: fai1.user_entity_id=l_roe_date_id and
313: fnd_date.canonical_to_date(fai1.value) between
314: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
315: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
316: fai1.context1 = fai2.context1 and
317: fai2.user_entity_id = l_roe_payroll_id and

Line 314: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and

310: ppa.payroll_action_id = paa.payroll_action_id and
311: paa.assignment_action_id = fai1.context1 and
312: fai1.user_entity_id=l_roe_date_id and
313: fnd_date.canonical_to_date(fai1.value) between
314: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
315: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
316: fai1.context1 = fai2.context1 and
317: fai2.user_entity_id = l_roe_payroll_id and
318: paa.assignment_id = paf.assignment_id and

Line 315: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and

311: paa.assignment_action_id = fai1.context1 and
312: fai1.user_entity_id=l_roe_date_id and
313: fnd_date.canonical_to_date(fai1.value) between
314: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
315: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
316: fai1.context1 = fai2.context1 and
317: fai2.user_entity_id = l_roe_payroll_id and
318: paa.assignment_id = paf.assignment_id and
319: fnd_date.canonical_to_date(fai1.value) between

Line 319: fnd_date.canonical_to_date(fai1.value) between

315: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
316: fai1.context1 = fai2.context1 and
317: fai2.user_entity_id = l_roe_payroll_id and
318: paa.assignment_id = paf.assignment_id and
319: fnd_date.canonical_to_date(fai1.value) between
320: paf.effective_start_date and
321: paf.effective_end_date and
322: paf.assignment_type = 'E' and
323: ppr.payroll_action_id = p_pactid

Line 346: fnd_date.canonical_to_date(fai1.value) between

342: paa.tax_unit_id = l_gre_id and
343: paa.assignment_id = l_assignment_id and
344: paa.assignment_action_id = fai1.context1 and
345: fai1.user_entity_id = l_roe_date_id and
346: fnd_date.canonical_to_date(fai1.value) between
347: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
348: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
349: fai1.context1 = fai2.context1 and
350: fai2.user_entity_id = l_roe_payroll_id and

Line 347: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and

343: paa.assignment_id = l_assignment_id and
344: paa.assignment_action_id = fai1.context1 and
345: fai1.user_entity_id = l_roe_date_id and
346: fnd_date.canonical_to_date(fai1.value) between
347: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
348: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
349: fai1.context1 = fai2.context1 and
350: fai2.user_entity_id = l_roe_payroll_id and
351: fai2.value = l_payroll_id;

Line 348: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and

344: paa.assignment_action_id = fai1.context1 and
345: fai1.user_entity_id = l_roe_date_id and
346: fnd_date.canonical_to_date(fai1.value) between
347: fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
348: fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
349: fai1.context1 = fai2.context1 and
350: fai2.user_entity_id = l_roe_payroll_id and
351: fai2.value = l_payroll_id;
352: