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 6801: ,fnd_date.canonical_to_date(ip_assessment_date_lower)

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

Line 6802: ,fnd_date.canonical_to_date(ip_assessment_date_upper)

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

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

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

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

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

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

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

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

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