APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 165: FROM pn_var_grp_dates_all gd

161: AND nvl(decode(inv.adjust_num,0,(inv.actual_invoiced_amount-NVL(inv.for_per_rent,0)),
162: inv.actual_invoiced_amount),0) <> 0
163: AND inv.variance_term_status = decode(p_period_id,null,'N','Y')
164: AND not exists (SELECT null
165: FROM pn_var_grp_dates_all gd
166: WHERE gd.invoice_date = inv.invoice_date
167: AND gd.period_id = inv.period_id
168: AND gd.var_rent_id = inv.var_rent_id
169: AND nvl(gd.forecasted_exp_code,'N') = 'N')

Line 730: FROM pn_var_grp_dates_all

726:
727: -- Get the details of
728: /*CURSOR invoice_date_c IS
729: SELECT DISTINCT inv_start_date
730: FROM pn_var_grp_dates_all
731: WHERE var_rent_id = p_var_rent_id
732: AND invoice_date = p_invoice_date;*/
733:
734:

Line 837: FROM pn_var_grp_dates_all

833: BEGIN
834:
835: /*SELECT distinct inv_schedule_date
836: INTO l_payment_start_date
837: FROM pn_var_grp_dates_all
838: WHERE period_id = p_period_id
839: AND invoice_date = p_invoice_date;*/
840: --
841: -- FOR rec IN invoice_date_c LOOP

Line 1175: FROM pn_var_grp_dates_all gd

1171: SELECT start_date, end_date, line_item_id
1172: FROM pn_var_vol_hist_all vol,
1173: (SELECT gd.period_id,
1174: gd.grp_date_id
1175: FROM pn_var_grp_dates_all gd
1176: WHERE gd.period_id= p_prd_id
1177: AND gd.invoice_date = p_inv_dt OR p_inv_dt IS NULL
1178: )itemp
1179: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1194: FROM pn_var_grp_dates_all gd

1190: SELECT start_date, end_date, line_item_id
1191: FROM pn_var_vol_hist_all vol,
1192: (SELECT gd.period_id,
1193: gd.grp_date_id
1194: FROM pn_var_grp_dates_all gd
1195: WHERE gd.period_id= p_prd_id
1196: AND gd.invoice_date <= p_inv_dt
1197: )itemp
1198: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1214: FROM pn_var_grp_dates_all gd

1210: SELECT start_date, end_date, line_item_id
1211: FROM pn_var_vol_hist_all vol,
1212: (SELECT gd.period_id,
1213: gd.grp_date_id
1214: FROM pn_var_grp_dates_all gd
1215: WHERE gd.period_id= p_prd_id
1216: AND gd.invoice_date >= p_inv_dt
1217: )itemp
1218: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1243: FROM pn_var_grp_dates_all

1239:
1240: -- Get invoice period dates
1241: CURSOR inv_prd_cur(p_prd_id IN NUMBER,p_inv_dt IN DATE) IS
1242: SELECT inv_start_date ,inv_end_date
1243: FROM pn_var_grp_dates_all
1244: WHERE period_id = p_prd_id
1245: AND invoice_date = p_inv_dt;
1246:
1247: l_prorul VARCHAR2(5):=NULL;

Line 1600: FROM pn_var_grp_dates_all

1596: -- Get the details of
1597: CURSOR inv_dt_cur
1598: IS
1599: SELECT invoice_date
1600: FROM pn_var_grp_dates_all
1601: WHERE period_id = p_prd_id
1602: AND p_date BETWEEN inv_start_date AND inv_end_date ;
1603:
1604: l_inv_date DATE;

Line 1668: FROM pn_var_grp_dates_all gd

1664: SELECT start_date, end_date, line_item_id
1665: FROM pn_var_vol_hist_all vol,
1666: (SELECT gd.period_id,
1667: gd.grp_date_id
1668: FROM pn_var_grp_dates_all gd
1669: WHERE gd.period_id= p_prd_id
1670: AND gd.invoice_date = p_inv_dt OR p_inv_dt IS NULL
1671: )itemp
1672: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1687: FROM pn_var_grp_dates_all gd

1683: SELECT start_date, end_date, line_item_id
1684: FROM pn_var_vol_hist_all vol,
1685: (SELECT gd.period_id,
1686: gd.grp_date_id
1687: FROM pn_var_grp_dates_all gd
1688: WHERE gd.period_id= p_prd_id
1689: AND gd.invoice_date = p_inv_dt OR p_inv_dt IS NULL
1690: )itemp
1691: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1708: FROM pn_var_grp_dates_all

1704:
1705: -- Get invoice period dates
1706: CURSOR inv_prd_cur(p_prd_id IN NUMBER,p_inv_dt IN DATE) IS
1707: SELECT inv_start_date ,inv_end_date
1708: FROM pn_var_grp_dates_all
1709: WHERE period_id = p_prd_id
1710: AND invoice_date = p_inv_dt;
1711:
1712: l_line_id NUMBER:= NULL;