APPS.PN_VAR_RENT_CALC_PKG dependencies on DUAL

Line 211: FROM dual

207: CURSOR approved_sales_c( p_line_id IN NUMBER
208: ,p_grp_id IN NUMBER) IS
209: SELECT
210: 1
211: FROM dual
212: WHERE
213: EXISTS
214: (SELECT
215: vol_hist_id

Line 2181: FROM DUAL

2177: CURSOR vol_exists_c(ip_var_rent_id NUMBER,
2178: ip_invoice_date DATE
2179: ) IS
2180: SELECT 1 as vol_exists
2181: FROM DUAL
2182: WHERE exists(
2183: SELECT vol_hist_id
2184: FROM pn_var_vol_hist_all
2185: WHERE grp_date_id in(

Line 4726: FROM DUAL

4722: CURSOR vol_exists_c(ip_var_rent_id NUMBER,
4723: ip_invoice_date DATE
4724: ) IS
4725: SELECT 1 as vol_exists
4726: FROM DUAL
4727: WHERE exists(
4728: SELECT vol_hist_id
4729: FROM pn_var_vol_hist_all
4730: WHERE grp_date_id in(

Line 8888: FROM dual

8884: IS
8885: -- Get roll fwd flag for 1st partial period
8886: CURSOR get_fst_prd_flag(p_vrent_id IN NUMBER,p_status IN VARCHAR2) IS
8887: SELECT 'Y' fst_prd_flag
8888: FROM dual
8889: WHERE EXISTS
8890: (SELECT period_id FROM pn_var_periods_all vp
8891: WHERE period_num=1
8892: AND var_rent_id=p_vrent_id

Line 9197: FROM dual

9193: -- exists in pn_var_abatements_all
9194: CURSOR check_abtmt_exists(p_inv_id IN NUMBER,p_pmt_id IN NUMBER)
9195: IS
9196: SELECT 'Y' abt_exists
9197: FROM dual
9198: WHERE EXISTS ( SELECT NULL
9199: FROM pn_var_abatements_all
9200: WHERE var_rent_inv_id=p_inv_id
9201: AND payment_term_id = p_pmt_id );

Line 9539: FROM dual

9535:
9536: -- Check if abatement exists for this pmt term and invoice id combination
9537: CURSOR check_abtmt_exists(pmt_term_id IN NUMBER,invoice_id IN NUMBER) IS
9538: SELECT 'N'
9539: FROM dual
9540: WHERE NOT EXISTS ( SELECT NULL FROM pn_var_abatements_all
9541: WHERE payment_term_id=pmt_term_id
9542: AND var_rent_inv_id=invoice_id);
9543:

Line 9668: FROM dual

9664:
9665: -- Get the details of
9666: CURSOR check_abtmt_exists(pmt_term_id IN NUMBER,invoice_id IN NUMBER) IS
9667: SELECT 'N'
9668: FROM dual
9669: WHERE NOT EXISTS ( SELECT NULL FROM pn_var_abatements_all
9670: WHERE payment_term_id=pmt_term_id
9671: AND var_rent_inv_id=invoice_id);
9672:

Line 10357: FROM DUAL

10353: -- Get the details of
10354: CURSOR incl_prd(p_prd_id IN NUMBER)
10355: IS
10356: SELECT 'y' AS include_flag
10357: FROM DUAL
10358: WHERE NOT EXISTS (SELECT NULL
10359: FROM pn_var_rent_inv_all vinv
10360: WHERE vinv.ACTUAL_INVOICED_AMOUNT <> 0
10361: AND vinv.period_id = p_prd_id