APPS.PN_VAR_RENT_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 2694: FROM pn_payment_items_all

2690:
2691: DELETE FROM pn_payment_schedules_all
2692: WHERE payment_schedule_id IN
2693: (SELECT payment_schedule_id
2694: FROM pn_payment_items_all
2695: WHERE NVL(export_to_ar_flag,'N') <>'Y'
2696: AND payment_term_id IN
2697: (SELECT payment_term_id
2698: FROM pn_payment_terms

Line 2708: DELETE FROM pn_payment_items_all

2704: )
2705: )
2706: AND payment_status_lookup_code <>'APPROVED';
2707:
2708: DELETE FROM pn_payment_items_all
2709: WHERE payment_term_id IN
2710: (SELECT payment_term_id
2711: FROM pn_payment_terms_all
2712: WHERE var_rent_inv_id IN

Line 3552: DELETE FROM pn_payment_items_all

3548: l_lines_exist := PN_VAR_RENT_PKG.find_if_lines_exist(p_var_rent_id, NULL, l_date);
3549:
3550: l_constr_exist:= PN_VAR_RENT_PKG.find_if_constr_exist(p_var_rent_id, l_date);
3551:
3552: DELETE FROM pn_payment_items_all
3553: WHERE payment_term_id IN
3554: (SELECT payment_term_id
3555: FROM pn_payment_terms_all
3556: WHERE var_rent_inv_id IN

Line 3567: FROM pn_payment_items_all

3563:
3564: DELETE FROM pn_payment_schedules_all
3565: WHERE payment_schedule_id IN
3566: (SELECT payment_schedule_id
3567: FROM pn_payment_items_all
3568: WHERE export_to_ar_flag <>'Y'
3569: AND payment_term_id IN
3570: (SELECT payment_term_id
3571: FROM pn_payment_terms

Line 4425: FROM pn_payment_items_ALL item,

4421: IF (p_base_rent_type = 'ROLLING') THEN
4422:
4423: SELECT SUM(item.ACTUAL_AMOUNT)
4424: INTO l_base_rent
4425: FROM pn_payment_items_ALL item,
4426: pn_payment_terms_ALL term,
4427: pn_var_periods_ALL per,
4428: pn_var_rents_ALL var,
4429: pn_payment_schedules_all sched

Line 4449: FROM pn_payment_items_ALL item,

4445: ELSIF (p_base_rent_type = 'FIXED') THEN
4446:
4447: SELECT SUM(item.ACTUAL_AMOUNT)
4448: INTO l_base_rent
4449: FROM pn_payment_items_ALL item,
4450: pn_payment_terms_ALL term,
4451: pn_var_periods_ALL per,
4452: pn_var_rents_ALL var,
4453: pn_payment_schedules_all sched

Line 5340: FROM PN_PAYMENT_ITEMS_ALL ppi,

5336: IS
5337:
5338: CURSOR C_UPD_TERMS IS
5339: SELECT ppi.payment_term_id
5340: FROM PN_PAYMENT_ITEMS_ALL ppi,
5341: PN_PAYMENT_TERMS_ALL ppt,
5342: PN_VAR_RENT_INV_ALL pvri,
5343: PN_LEASES_ALL pl
5344: WHERE DECODE(pl.lease_class_code, 'DIRECT', NVL(ppi.transferred_to_ap_flag,'N'),