APPS.PN_VAR_RENT_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 2698: FROM pn_payment_items_all

2694:
2695: DELETE FROM pn_payment_schedules_all
2696: WHERE payment_schedule_id IN
2697: (SELECT payment_schedule_id
2698: FROM pn_payment_items_all
2699: WHERE NVL(export_to_ar_flag,'N') <>'Y'
2700: AND payment_term_id IN
2701: (SELECT payment_term_id
2702: FROM pn_payment_terms

Line 2712: DELETE FROM pn_payment_items_all

2708: )
2709: )
2710: AND payment_status_lookup_code <>'APPROVED';
2711:
2712: DELETE FROM pn_payment_items_all
2713: WHERE payment_term_id IN
2714: (SELECT payment_term_id
2715: FROM pn_payment_terms_all
2716: WHERE var_rent_inv_id IN

Line 3556: DELETE FROM pn_payment_items_all

3552: l_lines_exist := PN_VAR_RENT_PKG.find_if_lines_exist(p_var_rent_id, NULL, l_date);
3553:
3554: l_constr_exist:= PN_VAR_RENT_PKG.find_if_constr_exist(p_var_rent_id, l_date);
3555:
3556: DELETE FROM pn_payment_items_all
3557: WHERE payment_term_id IN
3558: (SELECT payment_term_id
3559: FROM pn_payment_terms_all
3560: WHERE var_rent_inv_id IN

Line 3571: FROM pn_payment_items_all

3567:
3568: DELETE FROM pn_payment_schedules_all
3569: WHERE payment_schedule_id IN
3570: (SELECT payment_schedule_id
3571: FROM pn_payment_items_all
3572: WHERE export_to_ar_flag <>'Y'
3573: AND payment_term_id IN
3574: (SELECT payment_term_id
3575: FROM pn_payment_terms

Line 4429: FROM pn_payment_items_ALL item,

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

Line 4453: FROM pn_payment_items_ALL item,

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

Line 5344: FROM PN_PAYMENT_ITEMS_ALL ppi,

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