APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_RENTS_ALL

Line 1443: from pn_var_rents_all

1439: select commencement_date,
1440: TO_DATE('31-12-'||TO_CHAR(commencement_date,'YYYY'),'DD-MM-YYYY') year,
1441: TO_DATE(TO_CHAR(commencement_date,'DD-MM-')||
1442: TO_CHAR(TO_NUMBER(TO_CHAR(commencement_date,'YYYY'))+1), 'DD-MM-YYYY')-1 end_date
1443: from pn_var_rents_all
1444: where var_rent_id = p_var_rent_id;
1445:
1446: /*cursor csr_group_sales (p_var_rent_id NUMBER, p_date DATE) IS
1447: select grp_date_id,bkpt_start_date, bkpt_end_date,

Line 1552: pn_var_rents_ALL var,

1548: SELECT sum(item.ACTUAL_AMOUNT)
1549: INTO l_base_rent
1550: FROM pn_payment_items_ALL item,
1551: pn_payment_terms_ALL term,
1552: pn_var_rents_ALL var,
1553: pn_payment_schedules sched
1554: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
1555: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
1556: AND term.lease_id = var.lease_id

Line 1572: pn_var_rents_ALL var,

1568: SELECT sum(item.ACTUAL_AMOUNT)
1569: INTO l_base_rent
1570: FROM pn_payment_items_ALL item,
1571: pn_payment_terms_ALL term,
1572: pn_var_rents_ALL var,
1573: pn_payment_schedules sched
1574: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
1575: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
1576: AND term.lease_id = var.lease_id

Line 1633: from pn_var_rents_all

1629: select TO_DATE(TO_CHAR(termination_date,'DD-MM-')||
1630: TO_CHAR(TO_NUMBER(TO_CHAR(termination_date,'YYYY'))-1), 'DD-MM-YYYY')+1 start_date,
1631: TO_DATE('1-1-'||TO_CHAR(termination_date,'YYYY'),'DD-MM-YYYY') year,
1632: termination_date
1633: from pn_var_rents_all
1634: where var_rent_id = p_var_rent_id;
1635:
1636: /*cursor csr_group_sales (p_var_rent_id NUMBER, p_date DATE) IS
1637: select grp_date_id,bkpt_start_date, bkpt_end_date,