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.PN_INDEX_AMOUNT_PKG dependencies on FND_DATE

Line 6799: ,fnd_date.canonical_to_date(ip_assessment_date_lower)

6795:
6796: FOR il_rec IN il_recs (
6797: ip_index_lease_number_lower
6798: ,ip_index_lease_number_upper
6799: ,fnd_date.canonical_to_date(ip_assessment_date_lower)
6800: ,fnd_date.canonical_to_date(ip_assessment_date_upper)
6801: ,ip_lease_class
6802: ,ip_main_lease_number
6803: ,ip_location_code

Line 6800: ,fnd_date.canonical_to_date(ip_assessment_date_upper)

6796: FOR il_rec IN il_recs (
6797: ip_index_lease_number_lower
6798: ,ip_index_lease_number_upper
6799: ,fnd_date.canonical_to_date(ip_assessment_date_lower)
6800: ,fnd_date.canonical_to_date(ip_assessment_date_upper)
6801: ,ip_lease_class
6802: ,ip_main_lease_number
6803: ,ip_location_code
6804: ,ip_user_responsible --,ip_recalculate

Line 7276: nvl(fnd_date.canonical_to_date (p_assessment_date_lower), pilp.assessment_date) AND

7272: AND (pl.lease_num BETWEEN
7273: nvl(p_main_lease_number_lower, pl.lease_num) AND
7274: nvl(p_main_lease_number_upper, pl.lease_num))
7275: AND (pilp.assessment_date BETWEEN
7276: nvl(fnd_date.canonical_to_date (p_assessment_date_lower), pilp.assessment_date) AND
7277: nvl(fnd_date.canonical_to_date (p_assessment_date_upper), pilp.assessment_date))
7278: AND (pl.lease_class_code = p_lease_class
7279: OR p_lease_class IS NULL)
7280: AND (pil.location_id = p_location_code

Line 7277: nvl(fnd_date.canonical_to_date (p_assessment_date_upper), pilp.assessment_date))

7273: nvl(p_main_lease_number_lower, pl.lease_num) AND
7274: nvl(p_main_lease_number_upper, pl.lease_num))
7275: AND (pilp.assessment_date BETWEEN
7276: nvl(fnd_date.canonical_to_date (p_assessment_date_lower), pilp.assessment_date) AND
7277: nvl(fnd_date.canonical_to_date (p_assessment_date_upper), pilp.assessment_date))
7278: AND (pl.lease_class_code = p_lease_class
7279: OR p_lease_class IS NULL)
7280: AND (pil.location_id = p_location_code
7281: OR p_location_code IS NULL)

Line 7285: nvl(fnd_date.canonical_to_date (p_payment_start_date_lower), ppt.start_date) AND

7281: OR p_location_code IS NULL)
7282: AND (pil.abstracted_by = p_user_responsible
7283: OR p_user_responsible IS NULL)
7284: AND (ppt.start_date BETWEEN
7285: nvl(fnd_date.canonical_to_date (p_payment_start_date_lower), ppt.start_date) AND
7286: nvl(fnd_date.canonical_to_date (p_payment_start_date_upper), ppt.start_date))
7287: AND ((p_approve_normalize_only = 'Y'
7288: AND NVL (ppt.normalize, 'N') = 'Y')
7289: OR p_approve_normalize_only = 'N')

Line 7286: nvl(fnd_date.canonical_to_date (p_payment_start_date_upper), ppt.start_date))

7282: AND (pil.abstracted_by = p_user_responsible
7283: OR p_user_responsible IS NULL)
7284: AND (ppt.start_date BETWEEN
7285: nvl(fnd_date.canonical_to_date (p_payment_start_date_lower), ppt.start_date) AND
7286: nvl(fnd_date.canonical_to_date (p_payment_start_date_upper), ppt.start_date))
7287: AND ((p_approve_normalize_only = 'Y'
7288: AND NVL (ppt.normalize, 'N') = 'Y')
7289: OR p_approve_normalize_only = 'N')
7290: AND ppt.status = p_payment_status;