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

Line 119: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_start_date)

115: and eev2.element_entry_id = ent.element_entry_id
116: and eev3.element_entry_id = ent.element_entry_id
117: and (ent.element_entry_id <> p_element_entry_id
118: or p_element_entry_id is null)
119: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_start_date)
120: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
121: OR (eev3.screen_entry_value is NULL
122: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
123: OR eev2.screen_entry_value is NULL )))

Line 120: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

116: and eev3.element_entry_id = ent.element_entry_id
117: and (ent.element_entry_id <> p_element_entry_id
118: or p_element_entry_id is null)
119: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_start_date)
120: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
121: OR (eev3.screen_entry_value is NULL
122: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
123: OR eev2.screen_entry_value is NULL )))
124: and p_start_date between

Line 122: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

118: or p_element_entry_id is null)
119: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_start_date)
120: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
121: OR (eev3.screen_entry_value is NULL
122: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
123: OR eev2.screen_entry_value is NULL )))
124: and p_start_date between
125: eev1.effective_start_date and eev1.effective_end_date
126: and p_start_date between

Line 170: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_start_date)

166: and eev1.element_entry_id = ent.element_entry_id
167: and eev2.element_entry_id = ent.element_entry_id
168: and (ent.element_entry_id <> p_element_entry_id
169: or p_element_entry_id is null)
170: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_start_date)
171: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
172: OR (eev2.screen_entry_value is NULL));
173:
174: cursor c_tax_credit_starting(p_asg in NUMBER,

Line 171: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

167: and eev2.element_entry_id = ent.element_entry_id
168: and (ent.element_entry_id <> p_element_entry_id
169: or p_element_entry_id is null)
170: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_start_date)
171: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
172: OR (eev2.screen_entry_value is NULL));
173:
174: cursor c_tax_credit_starting(p_asg in NUMBER,
175: p_element_entry_id in NUMBER,

Line 206: and eev1.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

202: and eev2.element_entry_id = ent.element_entry_id
203: and eev3.element_entry_id = ent.element_entry_id
204: and (ent.element_entry_id <> p_element_entry_id
205: or p_element_entry_id is null)
206: and eev1.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
207: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
208: OR (eev3.screen_entry_value is NULL
209: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
210: OR eev2.screen_entry_value is NULL )));

Line 207: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

203: and eev3.element_entry_id = ent.element_entry_id
204: and (ent.element_entry_id <> p_element_entry_id
205: or p_element_entry_id is null)
206: and eev1.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
207: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
208: OR (eev3.screen_entry_value is NULL
209: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
210: OR eev2.screen_entry_value is NULL )));
211:

Line 209: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

205: or p_element_entry_id is null)
206: and eev1.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
207: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
208: OR (eev3.screen_entry_value is NULL
209: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
210: OR eev2.screen_entry_value is NULL )));
211:
212: cursor c_student_loan_starting(p_asg in NUMBER,
213: p_element_entry_id in NUMBER,

Line 238: and eev1.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

234: and eev1.element_entry_id = ent.element_entry_id
235: and eev2.element_entry_id = ent.element_entry_id
236: and (ent.element_entry_id <> p_element_entry_id
237: or p_element_entry_id is null)
238: and eev1.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
239: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
240: OR (eev2.screen_entry_value is NULL));
241:
242: cursor c_tax_credit_prior_to_runs(p_asg in NUMBER

Line 239: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

235: and eev2.element_entry_id = ent.element_entry_id
236: and (ent.element_entry_id <> p_element_entry_id
237: or p_element_entry_id is null)
238: and eev1.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
239: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
240: OR (eev2.screen_entry_value is NULL));
241:
242: cursor c_tax_credit_prior_to_runs(p_asg in NUMBER
243: ) is

Line 475: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_end_date)

471: and eev2.element_entry_id = ent.element_entry_id
472: and eev3.element_entry_id = ent.element_entry_id
473: and (ent.element_entry_id <> p_element_entry_id
474: or p_element_entry_id is null)
475: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_end_date)
476: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
477: OR (eev3.screen_entry_value is NULL
478: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
479: OR eev2.screen_entry_value is NULL )))

Line 476: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

472: and eev3.element_entry_id = ent.element_entry_id
473: and (ent.element_entry_id <> p_element_entry_id
474: or p_element_entry_id is null)
475: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_end_date)
476: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
477: OR (eev3.screen_entry_value is NULL
478: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
479: OR eev2.screen_entry_value is NULL )))
480: and p_start_date between

Line 478: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)

474: or p_element_entry_id is null)
475: and eev1.screen_entry_value <= fnd_date.date_to_canonical(p_end_date)
476: and (eev3.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
477: OR (eev3.screen_entry_value is NULL
478: and (eev2.screen_entry_value >= fnd_date.date_to_canonical(p_start_date)
479: OR eev2.screen_entry_value is NULL )))
480: and p_start_date between
481: eev1.effective_start_date and eev1.effective_end_date
482: and p_start_date between