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.PNP_UTIL_FUNC dependencies on PN_PAYMENT_TERMS_ALL

Line 2785: FROM pn_payment_terms_all

2781: FROM pn_payment_schedules_all s,
2782: pn_payment_items_all i
2783: WHERE i.payment_term_id IN
2784: (SELECT payment_term_id
2785: FROM pn_payment_terms_all
2786: WHERE lease_id = p_lease_ID
2787: AND start_date > p_termination_date
2788: AND normalize = 'Y')
2789: AND i.payment_schedule_id = s.payment_schedule_id

Line 2801: FROM pn_payment_terms_all t

2797: FROM pn_payment_schedules_all s,
2798: pn_payment_items_all i
2799: WHERE i.payment_term_id IN
2800: (SELECT t.payment_term_id
2801: FROM pn_payment_terms_all t
2802: WHERE t.lease_id = p_lease_ID
2803: AND t.normalize = 'Y')
2804: AND i.payment_schedule_id = s.payment_schedule_id
2805: AND s.payment_status_lookup_code = 'APPROVED'

Line 2818: FROM pn_payment_terms_all t

2814: FROM pn_payment_schedules_all s,
2815: pn_payment_items_all i
2816: WHERE i.payment_term_id IN
2817: (SELECT t.payment_term_id
2818: FROM pn_payment_terms_all t
2819: WHERE t.lease_id = p_lease_ID
2820: AND t.frequency_code = 'OT'
2821: AND NVL(t.normalize,'N')='N')
2822: AND i.payment_schedule_id = s.payment_schedule_id

Line 2833: FROM pn_payment_terms_all t

2829: FROM pn_payment_schedules_all s,
2830: pn_payment_items_all i
2831: WHERE i.payment_term_id IN
2832: (SELECT t.payment_term_id
2833: FROM pn_payment_terms_all t
2834: WHERE t.lease_id = p_lease_ID
2835: AND t.frequency_code = 'MON'
2836: AND NVL(t.normalize,'N')='N')
2837: AND i.payment_schedule_id = s.payment_schedule_id

Line 2848: FROM pn_payment_terms_all t

2844: FROM pn_payment_schedules_all s,
2845: pn_payment_items_all i
2846: WHERE i.payment_term_id IN
2847: (SELECT t.payment_term_id
2848: FROM pn_payment_terms_all t
2849: WHERE t.lease_id = p_lease_ID
2850: AND t.frequency_code IN ('QTR', 'SA', 'YR')
2851: AND NVL(t.normalize,'N')='N')
2852: AND i.payment_schedule_id = s.payment_schedule_id

Line 2864: FROM pn_payment_terms_all

2860: ,start_date
2861: ,end_date
2862: ,schedule_day
2863: ,frequency_code
2864: FROM pn_payment_terms_all
2865: WHERE lease_ID = p_lease_ID
2866: AND payment_term_ID IN
2867: (SELECT DISTINCT i.payment_term_ID
2868: FROM pn_payment_items_all i

Line 2893: FROM pn_payment_terms_all

2889: ,start_date
2890: ,end_date
2891: ,schedule_day
2892: ,frequency_code
2893: FROM pn_payment_terms_all
2894: WHERE payment_term_ID = p_term_ID;
2895:
2896: l_frequency NUMBER;
2897: l_sched_tbl PNP_UTIL_FUNC.virtual_sched_tbl_type;

Line 3122: FROM pn_payment_terms_all

3118: l_norm_trm_exsts BOOLEAN := FALSE;
3119:
3120: CURSOR csr_norm_term_exists(p_lease_id IN NUMBER) IS
3121: SELECT 1
3122: FROM pn_payment_terms_all
3123: WHERE NVL(normalize,'N') = 'Y'
3124: AND lease_id = p_lease_id;
3125:
3126: BEGIN

Line 3215: pn_payment_terms_all term,

3211:
3212: CURSOR csr_ot_item_end_date(p_term_id IN NUMBER) IS
3213: SELECT MAX(schedule_date) AS item_end_date
3214: FROM pn_payment_items_all item,
3215: pn_payment_terms_all term,
3216: pn_payment_schedules_all schd
3217: WHERE term.payment_term_id = p_term_id
3218: AND item.payment_term_id = term.payment_term_id
3219: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3227: pn_payment_terms_all term,

3223:
3224: CURSOR csr_mon_item_end_date(p_term_id IN NUMBER) IS
3225: SELECT LAST_DAY(MAX(schedule_date)) AS item_end_date
3226: FROM pn_payment_items_all item,
3227: pn_payment_terms_all term,
3228: pn_payment_schedules_all schd
3229: WHERE term.payment_term_id = p_term_id
3230: AND item.payment_term_id = term.payment_term_id
3231: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3239: pn_payment_terms_all term,

3235:
3236: CURSOR csr_qtr_item_end_date(p_term_id IN NUMBER) IS
3237: SELECT ADD_MONTHS(MAX(schedule_date),3) - 1 AS item_end_date
3238: FROM pn_payment_items_all item,
3239: pn_payment_terms_all term,
3240: pn_payment_schedules_all schd
3241: WHERE term.payment_term_id = p_term_id
3242: AND item.payment_term_id = term.payment_term_id
3243: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3251: pn_payment_terms_all term,

3247:
3248: CURSOR csr_sa_item_end_date(p_term_id IN NUMBER) IS
3249: SELECT ADD_MONTHS(MAX(schedule_date),6) - 1 AS item_end_date
3250: FROM pn_payment_items_all item,
3251: pn_payment_terms_all term,
3252: pn_payment_schedules_all schd
3253: WHERE term.payment_term_id = p_term_id
3254: AND item.payment_term_id = term.payment_term_id
3255: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3263: pn_payment_terms_all term,

3259:
3260: CURSOR csr_yr_item_end_date(p_term_id IN NUMBER) IS
3261: SELECT ADD_MONTHS(MAX(schedule_date),12) - 1 AS item_end_date
3262: FROM pn_payment_items_all item,
3263: pn_payment_terms_all term,
3264: pn_payment_schedules_all schd
3265: WHERE term.payment_term_id = p_term_id
3266: AND item.payment_term_id = term.payment_term_id
3267: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3323: FROM pn_payment_terms_all

3319: CURSOR csr_term_info(p_lease_ID IN NUMBER) IS
3320: SELECT frequency_code,
3321: payment_term_id,
3322: index_period_id
3323: FROM pn_payment_terms_all
3324: WHERE lease_id = p_lease_id
3325: AND NVL(status,'APPROVED') = 'APPROVED';
3326:
3327: l_item_end_dt_tbl pnp_util_func.item_end_dt_tbl_type;

Line 5105: FROM pn_payment_terms_all

5101: BEGIN
5102:
5103: SELECT NVL(normalize ,'N')
5104: INTO normalize_flag
5105: FROM pn_payment_terms_all
5106: WHERE payment_term_id = p_paymentTermId ;
5107:
5108: RETURN (normalize_flag);
5109:

Line 7919: UPDATE pn_payment_terms_all

7915: l_user NUMBER := fnd_global.user_id;
7916: BEGIN
7917:
7918: FORALL i IN 0 .. x_term_id_tbl.COUNT - 1
7919: UPDATE pn_payment_terms_all
7920: SET area = x_area_tbl(i),
7921: last_updated_by = l_user,
7922: last_update_date = SYSDATE
7923: WHERE payment_term_id = x_term_id_tbl(i);

Line 7947: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm

7943: CURSOR get_assoc_payment_terms_w_type IS
7944: SELECT 'Y' answer
7945: FROM pn_tenancies_all tnc
7946: WHERE tnc.tenancy_id = p_tenancy_id
7947: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm
7948: WHERE trm.lease_id = tnc.lease_id
7949: AND trm.location_id = tnc.location_id
7950: AND trm.area_type_code = p_type);
7951:

Line 7956: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm

7952: CURSOR get_assoc_payment_terms IS
7953: SELECT 'Y' answer
7954: FROM pn_tenancies_all tnc
7955: WHERE tnc.tenancy_id = p_tenancy_id
7956: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm
7957: WHERE trm.lease_id = tnc.lease_id
7958: AND trm.location_id = tnc.location_id);
7959:
7960: l_answer BOOLEAN := FALSE;

Line 8029: FROM pn_payment_terms_all trm,

8025: loc.location_type_lookup_code,
8026: loc.rentable_area,
8027: loc.usable_area,
8028: loc.assignable_area
8029: FROM pn_payment_terms_all trm,
8030: pn_locations_all loc
8031: WHERE trm.lease_id = p_lease_id
8032: AND loc.location_id = p_loc_id
8033: AND trm.location_id = p_loc_id

Line 8154: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE

8150: -- make sure the area and share pct is summed.
8151: -- HISTORY
8152: -- 21-APR-05 ftanudja o created. #4324777
8153: -- 01-SEP-05 Kiran o Changed the type of params from
8154: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
8155: ------------------------------------------------------------------------------
8156: FUNCTION fetch_tenancy_area (
8157: p_lease_id pn_payment_terms_all.lease_id%TYPE,
8158: p_location_id pn_payment_terms_all.location_id%TYPE,

Line 8157: p_lease_id pn_payment_terms_all.lease_id%TYPE,

8153: -- 01-SEP-05 Kiran o Changed the type of params from
8154: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
8155: ------------------------------------------------------------------------------
8156: FUNCTION fetch_tenancy_area (
8157: p_lease_id pn_payment_terms_all.lease_id%TYPE,
8158: p_location_id pn_payment_terms_all.location_id%TYPE,
8159: p_as_of_date pn_payment_terms_all.start_date%TYPE,
8160: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
8161: RETURN NUMBER

Line 8158: p_location_id pn_payment_terms_all.location_id%TYPE,

8154: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
8155: ------------------------------------------------------------------------------
8156: FUNCTION fetch_tenancy_area (
8157: p_lease_id pn_payment_terms_all.lease_id%TYPE,
8158: p_location_id pn_payment_terms_all.location_id%TYPE,
8159: p_as_of_date pn_payment_terms_all.start_date%TYPE,
8160: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
8161: RETURN NUMBER
8162: IS

Line 8159: p_as_of_date pn_payment_terms_all.start_date%TYPE,

8155: ------------------------------------------------------------------------------
8156: FUNCTION fetch_tenancy_area (
8157: p_lease_id pn_payment_terms_all.lease_id%TYPE,
8158: p_location_id pn_payment_terms_all.location_id%TYPE,
8159: p_as_of_date pn_payment_terms_all.start_date%TYPE,
8160: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
8161: RETURN NUMBER
8162: IS
8163:

Line 8160: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)

8156: FUNCTION fetch_tenancy_area (
8157: p_lease_id pn_payment_terms_all.lease_id%TYPE,
8158: p_location_id pn_payment_terms_all.location_id%TYPE,
8159: p_as_of_date pn_payment_terms_all.start_date%TYPE,
8160: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
8161: RETURN NUMBER
8162: IS
8163:
8164: CURSOR get_tenancy_info IS

Line 8272: FROM pn_payment_terms_all

8268: start_date,
8269: location_id,
8270: lease_id,
8271: DECODE(location_id, p_ofc_id, 'OFFICE', p_flr_id, 'FLOOR', p_bld_id, 'BUILDING') type
8272: FROM pn_payment_terms_all
8273: WHERE location_id IN (p_ofc_id, p_flr_id, p_bld_id)
8274: AND area_type_code IN ('LOCTN_RENTABLE','LOCTN_USABLE','LOCTN_ASSIGNABLE')
8275: AND start_date BETWEEN p_start_date AND p_end_date;
8276: