APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 162: FROM pn_var_grp_dates_all gd

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

Line 726: FROM pn_var_grp_dates_all

722:
723: -- Get the details of
724: /*CURSOR invoice_date_c IS
725: SELECT DISTINCT inv_start_date
726: FROM pn_var_grp_dates_all
727: WHERE var_rent_id = p_var_rent_id
728: AND invoice_date = p_invoice_date;*/
729:
730:

Line 833: FROM pn_var_grp_dates_all

829: BEGIN
830:
831: /*SELECT distinct inv_schedule_date
832: INTO l_payment_start_date
833: FROM pn_var_grp_dates_all
834: WHERE period_id = p_period_id
835: AND invoice_date = p_invoice_date;*/
836: --
837: -- FOR rec IN invoice_date_c LOOP

Line 1171: FROM pn_var_grp_dates_all gd

1167: SELECT start_date, end_date, line_item_id
1168: FROM pn_var_vol_hist_all vol,
1169: (SELECT gd.period_id,
1170: gd.grp_date_id
1171: FROM pn_var_grp_dates_all gd
1172: WHERE gd.period_id= p_prd_id
1173: AND gd.invoice_date = p_inv_dt OR p_inv_dt IS NULL
1174: )itemp
1175: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1190: FROM pn_var_grp_dates_all gd

1186: SELECT start_date, end_date, line_item_id
1187: FROM pn_var_vol_hist_all vol,
1188: (SELECT gd.period_id,
1189: gd.grp_date_id
1190: FROM pn_var_grp_dates_all gd
1191: WHERE gd.period_id= p_prd_id
1192: AND gd.invoice_date <= p_inv_dt
1193: )itemp
1194: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1210: FROM pn_var_grp_dates_all gd

1206: SELECT start_date, end_date, line_item_id
1207: FROM pn_var_vol_hist_all vol,
1208: (SELECT gd.period_id,
1209: gd.grp_date_id
1210: FROM pn_var_grp_dates_all gd
1211: WHERE gd.period_id= p_prd_id
1212: AND gd.invoice_date >= p_inv_dt
1213: )itemp
1214: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1239: FROM pn_var_grp_dates_all

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

Line 1596: FROM pn_var_grp_dates_all

1592: -- Get the details of
1593: CURSOR inv_dt_cur
1594: IS
1595: SELECT invoice_date
1596: FROM pn_var_grp_dates_all
1597: WHERE period_id = p_prd_id
1598: AND p_date BETWEEN inv_start_date AND inv_end_date ;
1599:
1600: l_inv_date DATE;

Line 1664: FROM pn_var_grp_dates_all gd

1660: SELECT start_date, end_date, line_item_id
1661: FROM pn_var_vol_hist_all vol,
1662: (SELECT gd.period_id,
1663: gd.grp_date_id
1664: FROM pn_var_grp_dates_all gd
1665: WHERE gd.period_id= p_prd_id
1666: AND gd.invoice_date = p_inv_dt OR p_inv_dt IS NULL
1667: )itemp
1668: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1683: FROM pn_var_grp_dates_all gd

1679: SELECT start_date, end_date, line_item_id
1680: FROM pn_var_vol_hist_all vol,
1681: (SELECT gd.period_id,
1682: gd.grp_date_id
1683: FROM pn_var_grp_dates_all gd
1684: WHERE gd.period_id= p_prd_id
1685: AND gd.invoice_date = p_inv_dt OR p_inv_dt IS NULL
1686: )itemp
1687: WHERE vol.grp_date_id = itemp.grp_date_id

Line 1704: FROM pn_var_grp_dates_all

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