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 PN_PAYMENT_TERMS_ALL

Line 403: FROM pn_payment_terms_all ppt

399: ,ppt.end_date
400: ,ppt.index_term_indicator
401: ,ppt.status
402: ,DECODE (ppt.normalize, 'Y', 'NORMALIZE') "NORMALIZE"
403: FROM pn_payment_terms_all ppt
404: WHERE ppt.index_period_id = ip_index_period_id
405: ORDER BY ppt.start_date;
406:
407: CURSOR index_periods_payments (

Line 418: FROM pn_payment_terms_all ppt

414: ,ppt.end_date
415: ,ppt.index_term_indicator
416: ,ppt.status
417: ,DECODE (ppt.normalize, 'Y', 'NORMALIZE') "NORMALIZE"
418: FROM pn_payment_terms_all ppt
419: WHERE ppt.index_period_id = ip_index_period_id
420: AND ( ppt.payment_term_id = ip_payment_term_id
421: OR ip_payment_term_id IS NULL
422: )

Line 831: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi

827: ,c_spread_frequency_one_time, 0
828: )
829: )
830: INTO p_prev_index_amount
831: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi
832: WHERE ppt.index_period_id = ppi.index_period_id
833: AND ppi.index_lease_id = p_index_lease_id
834: AND ppi.assessment_date < (SELECT assessment_date
835: FROM pn_index_lease_periods_all

Line 898: -- with flag 'I' or from pn_payment_terms_all

894: -- get_profile_value
895: -- 14-AUG-06 pikhar o Added check to find out if contributing terms have
896: -- include_in_var_rent = 'INCLUDE_RI'
897: -- 23-SEP-06 prabhakar o Modified the curosrs to fetch terms from pn_index_exclude_term_all
898: -- with flag 'I' or from pn_payment_terms_all
899: -- 27-NOV-07 acprakas o Bug#6457105. Modified to consider new values for system option incl_terms_by_default_flag.
900: --------------------------------------------------------------------------------------------
901:
902: PROCEDURE sum_payment_items (

Line 932: FROM pn_payment_terms_all ppt

928: CURSOR csr_exc_get_item_period (p_payment_type VARCHAR2,p_org_id NUMBER) IS
929: SELECT ppt.payment_term_id
930: ,NVL(ppt.actual_amount, ppt.estimated_amount)
931: ,ppt.frequency_code
932: FROM pn_payment_terms_all ppt
933: ,pn_index_leases_all pil
934: WHERE pil.index_lease_id = p_index_lease_id
935: AND ppt.lease_id = pil.lease_id
936: AND ppt.payment_term_type_code

Line 972: FROM pn_payment_terms_all ppt

968: CURSOR csr_exc_get_item_enddate (p_payment_type VARCHAR2, p_org_id NUMBER) IS
969: SELECT ppt.payment_term_id
970: ,NVL(ppt.actual_amount, ppt.estimated_amount)
971: ,ppt.frequency_code
972: FROM pn_payment_terms_all ppt
973: ,pn_index_leases_all pil
974: WHERE pil.index_lease_id = p_index_lease_id
975: AND ppt.lease_id = pil.lease_id
976: AND ppt.payment_term_type_code

Line 1014: FROM pn_payment_terms_all ppt

1010: CURSOR csr_inc_get_item_period (p_payment_type VARCHAR2,p_org_id NUMBER) IS
1011: SELECT ppt.payment_term_id
1012: ,NVL(ppt.actual_amount,ppt.estimated_amount)
1013: ,ppt.frequency_code
1014: FROM pn_payment_terms_all ppt
1015: ,pn_index_leases_all pil
1016: WHERE pil.index_lease_id = p_index_lease_id
1017: AND ppt.lease_id = pil.lease_id
1018: AND ppt.payment_term_type_code

Line 1050: FROM pn_payment_terms_all ppt

1046: CURSOR csr_inc_get_item_enddate (p_payment_type VARCHAR2,p_org_id NUMBER) IS
1047: SELECT ppt.payment_term_id
1048: ,NVL(ppt.actual_amount,ppt.estimated_amount)
1049: ,ppt.frequency_code
1050: FROM pn_payment_terms_all ppt
1051: ,pn_index_leases_all pil
1052: WHERE pil.index_lease_id = p_index_lease_id
1053: AND ppt.lease_id = pil.lease_id
1054: AND ppt.payment_term_type_code

Line 1244: FROM pn_payment_terms_all ppt

1240:
1241: IF l_increase_on is NOT NULL THEN
1242: SELECT include_in_var_rent
1243: INTO l_include_in_var_rent
1244: FROM pn_payment_terms_all ppt
1245: WHERE ppt.payment_term_id = l_payment_term_id
1246: AND ppt.payment_term_type_code = nvl(p_type_code,ppt.payment_term_type_code);
1247: ELSE
1248: SELECT include_in_var_rent

Line 1250: FROM pn_payment_terms_all ppt

1246: AND ppt.payment_term_type_code = nvl(p_type_code,ppt.payment_term_type_code);
1247: ELSE
1248: SELECT include_in_var_rent
1249: INTO l_include_in_var_rent
1250: FROM pn_payment_terms_all ppt
1251: WHERE ppt.payment_term_id = l_payment_term_id;
1252: END IF;
1253:
1254: IF l_count = 1 THEN

Line 2420: FROM pn_payment_terms_all ppt

2416:
2417: CURSOR c1 IS
2418: SELECT ppt.actual_amount
2419: ,ppt.frequency_code
2420: FROM pn_payment_terms_all ppt
2421: WHERE ppt.index_period_id = p_index_period_id
2422: AND ppt.index_term_indicator = c_index_pay_term_type_atlst;
2423:
2424: BEGIN

Line 2473: FROM pn_payment_terms_all ppt

2469: -- cursor to select all recurring payment that are APPROVED.
2470: --
2471: CURSOR c1 IS
2472: SELECT ppt.payment_term_id, ppt.actual_amount, ppt.frequency_code
2473: FROM pn_payment_terms_all ppt
2474: WHERE ppt.index_period_id = p_index_period_id
2475: AND ppt.status =c_payment_term_status_approved
2476: AND ppt.index_term_indicator = p_index_term_indicator;
2477: BEGIN

Line 2545: FROM pn_payment_terms_all ppt,

2541: ,ip_index_term_indicator IN VARCHAR2
2542: ,ip_normalize IN VARCHAR2
2543: ,ip_index_period_id IN NUMBER)IS
2544: SELECT ppt.payment_term_id, ppt.actual_amount,ppt.frequency_code
2545: FROM pn_payment_terms_all ppt,
2546: pn_payment_items_all ppi
2547: WHERE ppt.index_period_id = ip_index_period_id
2548: AND ppt.status =c_payment_term_status_approved
2549: AND ppt.index_term_indicator = ip_index_term_indicator

Line 2581: FROM pn_payment_terms_all

2577: BEGIN
2578:
2579: SELECT '1'
2580: INTO v_exists
2581: FROM pn_payment_terms_all
2582: WHERE index_period_id = p_index_period_id
2583: AND status = c_payment_term_status_approved
2584: AND index_term_indicator = p_index_term_indicator;
2585:

Line 3013: FROM pn_payment_terms_all ppt,

3009: ,ppt.frequency_code
3010: ,ppt.include_in_var_rent
3011: ,build_distributions_string (ppt.payment_term_id) "DISTRIBUTION_STRING"
3012: ,NVL (ppt.normalize, 'N') "NORMALIZE"
3013: FROM pn_payment_terms_all ppt,
3014: pn_index_leases_all pil
3015: WHERE pil.index_lease_id = ip_index_lease_id
3016: AND ppt.lease_id = pil.lease_id
3017: AND nvl(ppt.status,'-1') = decode(ppt.index_period_id,null,nvl(ppt.status,'-1'),'APPROVED')

Line 3073: FROM pn_payment_terms_all ppt

3069: ) IS
3070: SELECT ppt.payment_term_id,nvl(ppt.actual_amount,ppt.estimated_amount)
3071: ,ppt.frequency_code
3072: ,ppt.norm_start_date
3073: FROM pn_payment_terms_all ppt
3074: WHERE ppt.payment_purpose_code = ip_payment_purpose_code
3075: AND ppt.payment_term_type_code = ip_payment_term_type_code
3076: AND nvl(ppt.include_in_var_rent,'N') = nvl(ip_include_in_var_rent,'N')
3077: AND nvl(ppt.status,'-1') = decode(ppt.index_period_id,null,nvl(ppt.status,'-1'),'APPROVED')

Line 3133: FROM pn_payment_terms_all

3129: normalize,
3130: schedule_day,
3131: end_date,
3132: include_in_var_rent
3133: FROM pn_payment_terms_all
3134: WHERE lease_id = p_lease_id
3135: AND index_period_id = p_index_period_id
3136: AND status = c_payment_term_status_approved;
3137:

Line 3155: FROM pn_payment_terms_all ppt

3151: ,ip_index_period_id IN NUMBER
3152: ,ip_include_in_var_rent IN VARCHAR2
3153: ) IS
3154: SELECT nvl(ppt.actual_amount,0) actual_amount, ppt.index_term_indicator, ppt.payment_term_id
3155: FROM pn_payment_terms_all ppt
3156: WHERE ppt.payment_purpose_code = ip_payment_purpose_code
3157: AND ppt.payment_term_type_code = ip_payment_term_type_code
3158: AND ppt.index_period_id = ip_index_period_id
3159: AND nvl(ppt.status,'-1') = 'APPROVED'

Line 3207: pn_payment_terms_all term

3203: ,p_normalize pn_payment_terms.normalize%TYPE
3204: ) IS
3205: SELECT sum(item.actual_amount) sum_overlap_amt
3206: FROM pn_payment_items_all item,
3207: pn_payment_terms_all term
3208: WHERE item.payment_term_id = term.payment_term_id
3209: AND item.due_date BETWEEN p_assessment_date AND p_end_date
3210: AND term.index_period_id = p_index_period_id
3211: AND term.index_term_indicator = p_index_term_indicator

Line 3287: TYPE payment_term_tbl IS TABLE OF pn_payment_terms_all%ROWTYPE INDEX BY BINARY_INTEGER;

3283:
3284: exist_term_rec term_rec;
3285:
3286: TYPE exist_payment IS TABLE OF exist_term_rec%TYPE INDEX BY BINARY_INTEGER;
3287: TYPE payment_term_tbl IS TABLE OF pn_payment_terms_all%ROWTYPE INDEX BY BINARY_INTEGER;
3288: TYPE id_tbl IS TABLE OF pn_payment_terms.payment_term_id%TYPE INDEX BY BINARY_INTEGER;
3289:
3290: exist_term_tab exist_payment;
3291: appr_ind_lease_tbl exist_payment;

Line 4201: pn_payment_terms_all term

4197: IS
4198: CURSOR get_overlap_sum IS
4199: SELECT sum(item.actual_amount) sum_overlap_amt
4200: FROM pn_payment_items_all item,
4201: pn_payment_terms_all term
4202: WHERE item.payment_term_id = term.payment_term_id
4203: AND term.term_template_id = p_term_template_id
4204: AND term.index_period_id = p_index_period_id
4205: AND term.index_term_indicator = p_index_term_indicator

Line 4707: FROM pn_payment_terms_all

4703:
4704: IF v_normalized_amount_annual = 0 THEN
4705: SELECT count(*)
4706: INTO l_found_atlst_bb
4707: FROM pn_payment_terms_all
4708: WHERE index_period_id = p_index_period_id
4709: AND index_term_indicator = c_index_pay_term_type_atlst_bb;
4710: END IF;
4711:

Line 5145: v_org_id pn_payment_terms_all.org_id%type;

5141: v_location_id pn_payment_terms.location_id%type;
5142: v_payment_start_date DATE := null;
5143: v_term_end_date DATE := null;
5144: v_assessment_date DATE := null;
5145: v_org_id pn_payment_terms_all.org_id%type;
5146: v_area pn_payment_terms.area%TYPE;
5147: v_area_type_code pn_payment_terms.area_type_code%TYPE;
5148: l_org_id NUMBER;
5149: l_norm_st_date DATE := NULL;

Line 5150: v_include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE ;

5146: v_area pn_payment_terms.area%TYPE;
5147: v_area_type_code pn_payment_terms.area_type_code%TYPE;
5148: l_org_id NUMBER;
5149: l_norm_st_date DATE := NULL;
5150: v_include_in_var_rent pn_payment_terms_all.include_in_var_rent%TYPE ;
5151:
5152: CURSOR distributions (ip_term_template_id IN NUMBER)
5153: IS
5154: SELECT *

Line 5298: FROM pn_payment_terms_all

5294: ,v_attribute15
5295: ,v_frequency_code
5296: ,v_location_id
5297: ,v_org_id
5298: FROM pn_payment_terms_all
5299: WHERE payment_term_id = p_payment_term_id;
5300: ELSE
5301: SELECT name
5302: ,normalize

Line 6029: FROM pn_payment_terms_all

6025: AND lease.lease_id = p_lease_id;
6026:
6027: CURSOR get_extendable_terms(p_index_period_id NUMBER,l_term_date DATE) IS
6028: SELECT *
6029: FROM pn_payment_terms_all
6030: WHERE index_period_id = p_index_period_id
6031: AND end_date = l_term_date;
6032:
6033: l_comm_date DATE;

Line 6036: l_term_rec pn_payment_terms_all%ROWTYPE;

6032:
6033: l_comm_date DATE;
6034: l_term_date DATE;
6035: l_ext_end_dt DATE;
6036: l_term_rec pn_payment_terms_all%ROWTYPE;
6037: l_return_status VARCHAR2(100);
6038: l_schd_date DATE := NULL;
6039: l_schd_day NUMBER := NULL;
6040: l_terms_exist BOOLEAN := FALSE;

Line 6241: FROM pn_payment_terms_all ppt

6237: AND ilt.approved_flag <> c_payment_term_status_approved ;
6238:
6239: DELETE FROM pn_distributions_all
6240: WHERE payment_term_id IN (SELECT payment_term_id
6241: FROM pn_payment_terms_all ppt
6242: WHERE ppt.index_period_id = c_rec.index_period_id
6243: AND ppt.status <> c_payment_term_status_approved);
6244:
6245: DELETE FROM pn_payment_terms_all ppt

Line 6245: DELETE FROM pn_payment_terms_all ppt

6241: FROM pn_payment_terms_all ppt
6242: WHERE ppt.index_period_id = c_rec.index_period_id
6243: AND ppt.status <> c_payment_term_status_approved);
6244:
6245: DELETE FROM pn_payment_terms_all ppt
6246: WHERE ppt.index_period_id = c_rec.index_period_id
6247: AND ppt.status <> c_payment_term_status_approved;
6248:
6249: --

Line 6479: UPDATE pn_payment_terms_all

6475: x_return_status => l_return_status,
6476: x_return_message => op_msg);
6477:
6478: ELSE
6479: UPDATE pn_payment_terms_all
6480: SET end_date = l_ext_end_dt,
6481: last_update_date = SYSDATE,
6482: last_updated_by = fnd_global.user_id,
6483: last_update_login = fnd_global.login_id

Line 7118: from pn_payment_terms_all

7114: --
7115:
7116: select include_in_var_rent
7117: into l_include_in_var_rent
7118: from pn_payment_terms_all
7119: where payment_term_id = ip_index_pay_term_id;
7120:
7121: IF l_include_in_var_rent = 'INCLUDE_RI' THEN
7122: /* NBPs need to be recalculated */

Line 7123: update pn_payment_terms_all

7119: where payment_term_id = ip_index_pay_term_id;
7120:
7121: IF l_include_in_var_rent = 'INCLUDE_RI' THEN
7122: /* NBPs need to be recalculated */
7123: update pn_payment_terms_all
7124: set update_nbp_flag = 'Y'
7125: where payment_term_id = ip_index_pay_term_id;
7126: ELSE
7127: l_include_in_var_rent := NULL;

Line 7131: UPDATE pn_payment_terms_all

7127: l_include_in_var_rent := NULL;
7128: END IF;
7129:
7130:
7131: UPDATE pn_payment_terms_all
7132: SET status = c_payment_term_status_approved
7133: ,include_in_var_rent = l_include_in_var_rent
7134: ,last_update_date = SYSDATE
7135: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

Line 7265: ,pn_payment_terms_all ppt

7261: ,ppt.schedule_day
7262: FROM pn_leases_all pl
7263: ,pn_index_leases pil
7264: ,pn_index_lease_periods_all pilp
7265: ,pn_payment_terms_all ppt
7266: WHERE pl.lease_id = pil.lease_id
7267: AND pil.index_lease_id = pilp.index_lease_id
7268: AND pilp.index_period_id = ppt.index_period_id
7269: AND (pilp.index_period_id = p_index_period_id

Line 7304: FROM PN_PAYMENT_TERMS_ALL

7300:
7301: CURSOR terms_cur (p1_lease_id IN NUMBER)
7302: IS
7303: SELECT UPDATE_NBP_FLAG
7304: FROM PN_PAYMENT_TERMS_ALL
7305: WHERE lease_id = p1_lease_id
7306: FOR UPDATE NOWAIT;
7307:
7308: CURSOR bkhd_exists_cur

Line 7426: UPDATE pn_payment_terms_all

7422:
7423:
7424: END LOOP;
7425:
7426: UPDATE pn_payment_terms_all
7427: SET UPDATE_NBP_FLAG = NULL
7428: WHERE lease_id = il_rec.lease_id;
7429:
7430: