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_VAR_NATURAL_BP_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 335: FROM pn_payment_terms_all

331: p_bkpt_rate IN NUMBER)
332: IS
333: SELECT DISTINCT start_date FROM(
334: SELECT distinct GREATEST(start_date, p_bkhd_start_date) start_date
335: FROM pn_payment_terms_all
336: WHERE lease_id = p_lease_id
337: AND include_in_var_rent IN ('BASETERM','INCLUDE_RI')
338: AND index_period_id IS NULL
339: AND p_bkhd_start_date <= end_date

Line 343: FROM pn_payment_terms_all

339: AND p_bkhd_start_date <= end_date
340: AND p_bkhd_end_date >= start_date
341: UNION
342: SELECT distinct (LEAST(end_date, p_bkhd_end_date) + 1) start_date
343: FROM pn_payment_terms_all
344: WHERE lease_id = p_lease_id
345: AND include_in_var_rent IN ('BASETERM','INCLUDE_RI')
346: AND index_period_id IS NULL
347: AND p_bkhd_start_date <= end_date

Line 352: FROM pn_payment_terms_all

348: AND p_bkhd_end_date >= start_date
349: AND (LEAST(end_date, p_bkhd_end_date) + 1) <= p_bkhd_end_date
350: UNION
351: SELECT distinct GREATEST(start_date, p_bkhd_start_date) start_date
352: FROM pn_payment_terms_all
353: WHERE lease_id = p_lease_id
354: AND include_in_var_rent IN ('INCLUDE_RI')
355: AND index_period_id IS NOT NULL
356: AND status = 'APPROVED'

Line 361: FROM pn_payment_terms_all

357: AND p_bkhd_start_date <= end_date
358: AND p_bkhd_end_date >= start_date
359: UNION
360: SELECT distinct (LEAST(end_date, p_bkhd_end_date) + 1) start_date
361: FROM pn_payment_terms_all
362: WHERE lease_id = p_lease_id
363: AND include_in_var_rent IN ('INCLUDE_RI')
364: AND index_period_id IS NOT NULL
365: AND status = 'APPROVED'

Line 398: FROM pn_payment_terms_all

394: p_lease_id IN NUMBER)
395: IS
396: SELECT DISTINCT * from (
397: SELECT start_date, end_date, frequency_code, SUM(actual_amount) actual_amount
398: FROM pn_payment_terms_all
399: WHERE lease_id = p_lease_id
400: AND include_in_var_rent in ('BASETERM','INCLUDE_RI')
401: AND index_period_id IS NULL
402: AND p_det_st_dt <= end_date

Line 407: FROM pn_payment_terms_all

403: AND p_det_end_date >= start_date
404: GROUP by start_date, end_date, frequency_code, actual_amount
405: UNION
406: SELECT start_date, end_date, frequency_code, SUM(actual_amount) actual_amount
407: FROM pn_payment_terms_all
408: WHERE lease_id = p_lease_id
409: AND include_in_var_rent in ('INCLUDE_RI')
410: AND index_period_id IS NOT NULL
411: AND status = 'APPROVED'