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

Line 205: AND fnd_date.canonical_to_date(p_eff_start_date)

201: AND org_information_context = p_org_info_type_code
202: AND org_information1 = p_state
203: AND org_information2 = p_exemption_catg
204: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
205: AND fnd_date.canonical_to_date(p_eff_start_date)
206: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
207: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
208: >= fnd_date.canonical_to_date(org_information3);
209:

Line 206: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))

202: AND org_information1 = p_state
203: AND org_information2 = p_exemption_catg
204: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
205: AND fnd_date.canonical_to_date(p_eff_start_date)
206: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
207: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
208: >= fnd_date.canonical_to_date(org_information3);
209:
210: BEGIN

Line 207: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))

203: AND org_information2 = p_exemption_catg
204: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
205: AND fnd_date.canonical_to_date(p_eff_start_date)
206: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
207: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
208: >= fnd_date.canonical_to_date(org_information3);
209:
210: BEGIN
211: l_procedure := g_package ||'check_pt_exemptions';

Line 208: >= fnd_date.canonical_to_date(org_information3);

204: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
205: AND fnd_date.canonical_to_date(p_eff_start_date)
206: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
207: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
208: >= fnd_date.canonical_to_date(org_information3);
209:
210: BEGIN
211: l_procedure := g_package ||'check_pt_exemptions';
212: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

Line 285: (fnd_date.canonical_to_date(p_eff_start_date),

281: CLOSE c_dup_state;
282: pay_in_utils.set_location(g_debug,l_procedure,70);
283:
284: IF NOT pay_in_utils.validate_dates
285: (fnd_date.canonical_to_date(p_eff_start_date),
286: fnd_date.canonical_to_date(p_eff_end_date))
287: THEN
288: p_message_name := 'PER_IN_INCORRECT_DATES';
289: RETURN;

Line 286: fnd_date.canonical_to_date(p_eff_end_date))

282: pay_in_utils.set_location(g_debug,l_procedure,70);
283:
284: IF NOT pay_in_utils.validate_dates
285: (fnd_date.canonical_to_date(p_eff_start_date),
286: fnd_date.canonical_to_date(p_eff_end_date))
287: THEN
288: p_message_name := 'PER_IN_INCORRECT_DATES';
289: RETURN;
290: END IF;

Line 340: AND fnd_date.canonical_to_date(p_eff_start_date)

336: WHERE organization_id = p_organization_id
337: AND org_information_context = p_org_info_type_code
338: AND org_information1 = p_state
339: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
340: AND fnd_date.canonical_to_date(p_eff_start_date)
341: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
342: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
343: >= fnd_date.canonical_to_date(org_information3);
344:

Line 341: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))

337: AND org_information_context = p_org_info_type_code
338: AND org_information1 = p_state
339: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
340: AND fnd_date.canonical_to_date(p_eff_start_date)
341: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
342: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
343: >= fnd_date.canonical_to_date(org_information3);
344:
345:

Line 342: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))

338: AND org_information1 = p_state
339: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
340: AND fnd_date.canonical_to_date(p_eff_start_date)
341: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
342: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
343: >= fnd_date.canonical_to_date(org_information3);
344:
345:
346: BEGIN

Line 343: >= fnd_date.canonical_to_date(org_information3);

339: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)
340: AND fnd_date.canonical_to_date(p_eff_start_date)
341: <= fnd_date.canonical_to_date(NVL(org_information4,'4712/12/31 00:00:00'))
342: AND fnd_date.canonical_to_date(NVL(p_eff_end_date, '4712/12/31 00:00:00'))
343: >= fnd_date.canonical_to_date(org_information3);
344:
345:
346: BEGIN
347: l_procedure := g_package ||'check_pt_frequency';

Line 423: (fnd_date.canonical_to_date(p_eff_start_date),

419: CLOSE c_dup_state;
420: pay_in_utils.set_location(g_debug,l_procedure,70);
421:
422: IF NOT pay_in_utils.validate_dates
423: (fnd_date.canonical_to_date(p_eff_start_date),
424: fnd_date.canonical_to_date(p_eff_end_date))
425: THEN
426: p_message_name := 'PER_IN_INCORRECT_DATES';
427: RETURN;

Line 424: fnd_date.canonical_to_date(p_eff_end_date))

420: pay_in_utils.set_location(g_debug,l_procedure,70);
421:
422: IF NOT pay_in_utils.validate_dates
423: (fnd_date.canonical_to_date(p_eff_start_date),
424: fnd_date.canonical_to_date(p_eff_end_date))
425: THEN
426: p_message_name := 'PER_IN_INCORRECT_DATES';
427: RETURN;
428: END IF;