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.

[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_PAYMENT_TERMS_ALL

Line 2630: FROM pn_payment_terms_all

2626: FROM pn_payment_schedules_all s,
2627: pn_payment_items_all i
2628: WHERE i.payment_term_id IN
2629: (SELECT payment_term_id
2630: FROM pn_payment_terms_all
2631: WHERE lease_id = p_lease_ID
2632: AND start_date > p_termination_date
2633: AND normalize = 'Y')
2634: AND i.payment_schedule_id = s.payment_schedule_id

Line 2646: FROM pn_payment_terms_all t

2642: FROM pn_payment_schedules_all s,
2643: pn_payment_items_all i
2644: WHERE i.payment_term_id IN
2645: (SELECT t.payment_term_id
2646: FROM pn_payment_terms_all t
2647: WHERE t.lease_id = p_lease_ID
2648: AND t.normalize = 'Y')
2649: AND i.payment_schedule_id = s.payment_schedule_id
2650: AND s.payment_status_lookup_code = 'APPROVED'

Line 2663: FROM pn_payment_terms_all t

2659: FROM pn_payment_schedules_all s,
2660: pn_payment_items_all i
2661: WHERE i.payment_term_id IN
2662: (SELECT t.payment_term_id
2663: FROM pn_payment_terms_all t
2664: WHERE t.lease_id = p_lease_ID
2665: AND t.frequency_code = 'OT'
2666: AND NVL(t.normalize,'N')='N')
2667: AND i.payment_schedule_id = s.payment_schedule_id

Line 2678: FROM pn_payment_terms_all t

2674: FROM pn_payment_schedules_all s,
2675: pn_payment_items_all i
2676: WHERE i.payment_term_id IN
2677: (SELECT t.payment_term_id
2678: FROM pn_payment_terms_all t
2679: WHERE t.lease_id = p_lease_ID
2680: AND t.frequency_code = 'MON'
2681: AND NVL(t.normalize,'N')='N')
2682: AND i.payment_schedule_id = s.payment_schedule_id

Line 2693: FROM pn_payment_terms_all t

2689: FROM pn_payment_schedules_all s,
2690: pn_payment_items_all i
2691: WHERE i.payment_term_id IN
2692: (SELECT t.payment_term_id
2693: FROM pn_payment_terms_all t
2694: WHERE t.lease_id = p_lease_ID
2695: AND t.frequency_code IN ('QTR', 'SA', 'YR')
2696: AND NVL(t.normalize,'N')='N')
2697: AND i.payment_schedule_id = s.payment_schedule_id

Line 2709: FROM pn_payment_terms_all

2705: ,start_date
2706: ,end_date
2707: ,schedule_day
2708: ,frequency_code
2709: FROM pn_payment_terms_all
2710: WHERE lease_ID = p_lease_ID
2711: AND payment_term_ID IN
2712: (SELECT DISTINCT i.payment_term_ID
2713: FROM pn_payment_items_all i

Line 2738: FROM pn_payment_terms_all

2734: ,start_date
2735: ,end_date
2736: ,schedule_day
2737: ,frequency_code
2738: FROM pn_payment_terms_all
2739: WHERE payment_term_ID = p_term_ID;
2740:
2741: l_frequency NUMBER;
2742: l_sched_tbl PNP_UTIL_FUNC.virtual_sched_tbl_type;

Line 2967: FROM pn_payment_terms_all

2963: l_norm_trm_exsts BOOLEAN := FALSE;
2964:
2965: CURSOR csr_norm_term_exists(p_lease_id IN NUMBER) IS
2966: SELECT 1
2967: FROM pn_payment_terms_all
2968: WHERE NVL(normalize,'N') = 'Y'
2969: AND lease_id = p_lease_id;
2970:
2971: BEGIN

Line 3060: pn_payment_terms_all term,

3056:
3057: CURSOR csr_ot_item_end_date(p_term_id IN NUMBER) IS
3058: SELECT MAX(schedule_date) AS item_end_date
3059: FROM pn_payment_items_all item,
3060: pn_payment_terms_all term,
3061: pn_payment_schedules_all schd
3062: WHERE term.payment_term_id = p_term_id
3063: AND item.payment_term_id = term.payment_term_id
3064: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3072: pn_payment_terms_all term,

3068:
3069: CURSOR csr_mon_item_end_date(p_term_id IN NUMBER) IS
3070: SELECT LAST_DAY(MAX(schedule_date)) AS item_end_date
3071: FROM pn_payment_items_all item,
3072: pn_payment_terms_all term,
3073: pn_payment_schedules_all schd
3074: WHERE term.payment_term_id = p_term_id
3075: AND item.payment_term_id = term.payment_term_id
3076: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3084: pn_payment_terms_all term,

3080:
3081: CURSOR csr_qtr_item_end_date(p_term_id IN NUMBER) IS
3082: SELECT ADD_MONTHS(MAX(schedule_date),3) - 1 AS item_end_date
3083: FROM pn_payment_items_all item,
3084: pn_payment_terms_all term,
3085: pn_payment_schedules_all schd
3086: WHERE term.payment_term_id = p_term_id
3087: AND item.payment_term_id = term.payment_term_id
3088: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3096: pn_payment_terms_all term,

3092:
3093: CURSOR csr_sa_item_end_date(p_term_id IN NUMBER) IS
3094: SELECT ADD_MONTHS(MAX(schedule_date),6) - 1 AS item_end_date
3095: FROM pn_payment_items_all item,
3096: pn_payment_terms_all term,
3097: pn_payment_schedules_all schd
3098: WHERE term.payment_term_id = p_term_id
3099: AND item.payment_term_id = term.payment_term_id
3100: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3108: pn_payment_terms_all term,

3104:
3105: CURSOR csr_yr_item_end_date(p_term_id IN NUMBER) IS
3106: SELECT ADD_MONTHS(MAX(schedule_date),12) - 1 AS item_end_date
3107: FROM pn_payment_items_all item,
3108: pn_payment_terms_all term,
3109: pn_payment_schedules_all schd
3110: WHERE term.payment_term_id = p_term_id
3111: AND item.payment_term_id = term.payment_term_id
3112: AND item.payment_schedule_id = schd.payment_schedule_id

Line 3165: FROM pn_payment_terms_all

3161: CURSOR csr_term_info(p_lease_ID IN NUMBER) IS
3162: SELECT frequency_code,
3163: payment_term_id,
3164: index_period_id
3165: FROM pn_payment_terms_all
3166: WHERE lease_id = p_lease_id
3167: AND NVL(status,'APPROVED') = 'APPROVED';
3168:
3169: l_item_end_dt_tbl pnp_util_func.item_end_dt_tbl_type;

Line 4947: FROM pn_payment_terms_all

4943: BEGIN
4944:
4945: SELECT NVL(normalize ,'N')
4946: INTO normalize_flag
4947: FROM pn_payment_terms_all
4948: WHERE payment_term_id = p_paymentTermId ;
4949:
4950: RETURN (normalize_flag);
4951:

Line 7752: UPDATE pn_payment_terms_all

7748: l_user NUMBER := fnd_global.user_id;
7749: BEGIN
7750:
7751: FORALL i IN 0 .. x_term_id_tbl.COUNT - 1
7752: UPDATE pn_payment_terms_all
7753: SET area = x_area_tbl(i),
7754: last_updated_by = l_user,
7755: last_update_date = SYSDATE
7756: WHERE payment_term_id = x_term_id_tbl(i);

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

7776: CURSOR get_assoc_payment_terms_w_type IS
7777: SELECT 'Y' answer
7778: FROM pn_tenancies_all tnc
7779: WHERE tnc.tenancy_id = p_tenancy_id
7780: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm
7781: WHERE trm.lease_id = tnc.lease_id
7782: AND trm.location_id = tnc.location_id
7783: AND trm.area_type_code = p_type);
7784:

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

7785: CURSOR get_assoc_payment_terms IS
7786: SELECT 'Y' answer
7787: FROM pn_tenancies_all tnc
7788: WHERE tnc.tenancy_id = p_tenancy_id
7789: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm
7790: WHERE trm.lease_id = tnc.lease_id
7791: AND trm.location_id = tnc.location_id);
7792:
7793: l_answer BOOLEAN := FALSE;

Line 7862: FROM pn_payment_terms_all trm,

7858: loc.location_type_lookup_code,
7859: loc.rentable_area,
7860: loc.usable_area,
7861: loc.assignable_area
7862: FROM pn_payment_terms_all trm,
7863: pn_locations_all loc
7864: WHERE trm.lease_id = p_lease_id
7865: AND loc.location_id = p_loc_id
7866: AND trm.location_id = p_loc_id

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

7982: -- make sure the area and share pct is summed.
7983: -- HISTORY
7984: -- 21-APR-05 ftanudja o created. #4324777
7985: -- 01-SEP-05 Kiran o Changed the type of params from
7986: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
7987: ------------------------------------------------------------------------------
7988: FUNCTION fetch_tenancy_area (
7989: p_lease_id pn_payment_terms_all.lease_id%TYPE,
7990: p_location_id pn_payment_terms_all.location_id%TYPE,

Line 7989: p_lease_id pn_payment_terms_all.lease_id%TYPE,

7985: -- 01-SEP-05 Kiran o Changed the type of params from
7986: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
7987: ------------------------------------------------------------------------------
7988: FUNCTION fetch_tenancy_area (
7989: p_lease_id pn_payment_terms_all.lease_id%TYPE,
7990: p_location_id pn_payment_terms_all.location_id%TYPE,
7991: p_as_of_date pn_payment_terms_all.start_date%TYPE,
7992: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
7993: RETURN NUMBER

Line 7990: p_location_id pn_payment_terms_all.location_id%TYPE,

7986: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
7987: ------------------------------------------------------------------------------
7988: FUNCTION fetch_tenancy_area (
7989: p_lease_id pn_payment_terms_all.lease_id%TYPE,
7990: p_location_id pn_payment_terms_all.location_id%TYPE,
7991: p_as_of_date pn_payment_terms_all.start_date%TYPE,
7992: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
7993: RETURN NUMBER
7994: IS

Line 7991: p_as_of_date pn_payment_terms_all.start_date%TYPE,

7987: ------------------------------------------------------------------------------
7988: FUNCTION fetch_tenancy_area (
7989: p_lease_id pn_payment_terms_all.lease_id%TYPE,
7990: p_location_id pn_payment_terms_all.location_id%TYPE,
7991: p_as_of_date pn_payment_terms_all.start_date%TYPE,
7992: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
7993: RETURN NUMBER
7994: IS
7995:

Line 7992: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)

7988: FUNCTION fetch_tenancy_area (
7989: p_lease_id pn_payment_terms_all.lease_id%TYPE,
7990: p_location_id pn_payment_terms_all.location_id%TYPE,
7991: p_as_of_date pn_payment_terms_all.start_date%TYPE,
7992: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
7993: RETURN NUMBER
7994: IS
7995:
7996: CURSOR get_tenancy_info IS

Line 8104: FROM pn_payment_terms_all

8100: start_date,
8101: location_id,
8102: lease_id,
8103: DECODE(location_id, p_ofc_id, 'OFFICE', p_flr_id, 'FLOOR', p_bld_id, 'BUILDING') type
8104: FROM pn_payment_terms_all
8105: WHERE location_id IN (p_ofc_id, p_flr_id, p_bld_id)
8106: AND area_type_code IN ('LOCTN_RENTABLE','LOCTN_USABLE','LOCTN_ASSIGNABLE')
8107: AND start_date BETWEEN p_start_date AND p_end_date;
8108: