DBA Data[Home] [Help]

APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_SCHEDULES_ITEMS

Line 1710: l_freq := pn_schedules_items.get_frequency(p_freq_code);

1706:
1707: ELSE
1708:
1709: l_context:= 'getting proration rule';
1710: l_freq := pn_schedules_items.get_frequency(p_freq_code);
1711:
1712: SELECT payment_term_proration_rule
1713: INTO l_prorate_rule
1714: FROM pn_leases_all

Line 1742: l_last_sch_dt := PN_SCHEDULES_ITEMS.FIRST_DAY(ADD_MONTHS(p_trm_end_dt,((l_freq -1) * -1)));

1738: LAST_DAY(ADD_MONTHS(l_sch_str_dt, (l_freq-1))));
1739:
1740: IF l_sch_end_dt = LAST_DAY(p_trm_end_dt) THEN
1741:
1742: l_last_sch_dt := PN_SCHEDULES_ITEMS.FIRST_DAY(ADD_MONTHS(p_trm_end_dt,((l_freq -1) * -1)));
1743:
1744: END IF;
1745:
1746: /* We would need to do the pro-ration only IF the schedule IS the first or the last

Line 1754: PN_SCHEDULES_ITEMS.GET_AMOUNT(

1750:
1751: IF to_char(pnt_rec.schedule_date,'MM/YYYY') = to_char(p_trm_str_dt,'MM/YYYY') OR
1752: to_char(pnt_rec.schedule_date,'MM/YYYY') = to_char(l_last_sch_dt,'MM/YYYY') THEN
1753:
1754: PN_SCHEDULES_ITEMS.GET_AMOUNT(
1755: l_sch_str_dt,
1756: l_sch_end_dt,
1757: p_trm_str_dt,
1758: p_trm_end_dt,