APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_PERIODS

Line 198: g_period_id pn_var_periods.period_id%TYPE;

194:
195: /* global variables */
196: g_breakpoint_TYPE pn_var_bkpts_head.breakpoint_TYPE%TYPE;
197: g_var_rent_id pn_var_rents.var_rent_id%TYPE;
198: g_period_id pn_var_periods.period_id%TYPE;
199: g_invoice_date pn_var_grp_dates.invoice_date%TYPE;
200: g_group_date pn_var_grp_dates.group_date%TYPE;
201: g_invoice_on pn_var_rents.invoice_on%TYPE;
202: g_cumulative pn_var_rents.cumulative_vol%TYPE;

Line 208: g_period_date pn_var_periods.start_date%TYPE;

204: g_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
205: g_currency_code gl_sets_of_books.currency_code%TYPE;
206: g_precision number;
207: g_org_id pn_leases.org_id%TYPE;
208: g_period_date pn_var_periods.start_date%TYPE;
209:
210: /* Uncomment for multi-org support */
211: /*l_gt pn_mo_cache_utils.GlobalsTable; */
212:

Line 244: FROM pn_var_periods_all per,

240: CURSOR csr_get_lines(ip_line_item_id NUMBER) IS
241: SELECT lines.line_item_num,
242: lines.period_id,
243: lines.line_item_id
244: FROM pn_var_periods_all per,
245: pn_var_lines_all lines
246: WHERE lines.period_id= per.period_id
247: AND per.var_rent_id = p_var_rent_id
248: AND per.period_id = p_period_id

Line 2074: FROM pn_var_rents_all pvr , pn_var_periods_all pvp

2070:
2071:
2072: CURSOR first_period_cur IS
2073: SELECT pvp.period_id
2074: FROM pn_var_rents_all pvr , pn_var_periods_all pvp
2075: WHERE pvr.var_rent_id = p_var_rent_id
2076: AND pvr.var_rent_id = pvp.var_rent_id
2077: AND proration_rule IN ('FY', 'FLY')
2078: AND pvp.start_date = pvr.commencement_date;

Line 2345: FROM pn_var_periods_all

2341: SELECT period_id,
2342: period_num,
2343: start_date,
2344: end_date
2345: FROM pn_var_periods_all
2346: WHERE var_rent_id = ip_var_rent_id
2347: AND period_id = NVL(p_period_id,period_id)
2348: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
2349: AND period_num >= NVL(p_period_num_from,period_num)