APPS.PN_VAR_CHG_CAL_PKG dependencies on PN_VAR_RENT_DATES_ALL

Line 1449: FROM pn_var_rent_dates_all

1445: BEGIN
1446: --Findout invoicing freq
1447: SELECT invg_freq_code
1448: INTO l_invg_freq
1449: FROM pn_var_rent_dates_all
1450: WHERE var_rent_id = p_var_rent_id;
1451: /* DBMS_OUTPUT.PUT_LINE(' l_invg_freq:'||l_invg_freq); */
1452: pnp_debug_pkg.log(' l_invg_freq:'||l_invg_freq);
1453: EXCEPTION

Line 2856: FROM pn_var_rent_dates_all

2852: 'SA', 6,
2853: 'YR', 12,
2854: NULL)
2855: INTO l_invg_freq_code
2856: FROM pn_var_rent_dates_all
2857: WHERE var_rent_id = p_var_rent_id;
2858: /*DBMS_OUTPUT.PUT_LINE(' l_invg_freq_code:'||l_invg_freq_code);
2859: EXCEPTION
2860: WHEN OTHERS THEN

Line 3234: FROM pn_var_rent_dates_all

3230: WHERE var_rent_id = p_old_var_rent_id;
3231:
3232: CURSOR var_rent_dates_cur IS
3233: SELECT *
3234: FROM pn_var_rent_dates_all
3235: WHERE var_rent_id = p_old_var_rent_id;
3236:
3237: l_length NUMBER;
3238: l_instr NUMBER;