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 4638: FROM DUAL

4634: CURSOR vol_exists_c(ip_var_rent_id NUMBER,
4635: ip_invoice_date DATE
4636: ) IS
4637: SELECT 1 as vol_exists
4638: FROM DUAL
4639: WHERE exists(
4640: SELECT vol_hist_id
4641: FROM pn_var_vol_hist_all
4642: WHERE grp_date_id in(

Line 8833: FROM dual

8829: IS
8830: -- Get roll fwd flag for 1st partial period
8831: CURSOR get_fst_prd_flag(p_vrent_id IN NUMBER,p_status IN VARCHAR2) IS
8832: SELECT 'Y' fst_prd_flag
8833: FROM dual
8834: WHERE EXISTS
8835: (SELECT period_id FROM pn_var_periods_all vp
8836: WHERE period_num=1
8837: AND var_rent_id=p_vrent_id

Line 9142: FROM dual

9138: -- exists in pn_var_abatements_all
9139: CURSOR check_abtmt_exists(p_inv_id IN NUMBER,p_pmt_id IN NUMBER)
9140: IS
9141: SELECT 'Y' abt_exists
9142: FROM dual
9143: WHERE EXISTS ( SELECT NULL
9144: FROM pn_var_abatements_all
9145: WHERE var_rent_inv_id=p_inv_id
9146: AND payment_term_id = p_pmt_id );

Line 9484: FROM dual

9480:
9481: -- Check if abatement exists for this pmt term and invoice id combination
9482: CURSOR check_abtmt_exists(pmt_term_id IN NUMBER,invoice_id IN NUMBER) IS
9483: SELECT 'N'
9484: FROM dual
9485: WHERE NOT EXISTS ( SELECT NULL FROM pn_var_abatements_all
9486: WHERE payment_term_id=pmt_term_id
9487: AND var_rent_inv_id=invoice_id);
9488:

Line 9613: FROM dual

9609:
9610: -- Get the details of
9611: CURSOR check_abtmt_exists(pmt_term_id IN NUMBER,invoice_id IN NUMBER) IS
9612: SELECT 'N'
9613: FROM dual
9614: WHERE NOT EXISTS ( SELECT NULL FROM pn_var_abatements_all
9615: WHERE payment_term_id=pmt_term_id
9616: AND var_rent_inv_id=invoice_id);
9617:

Line 10302: FROM DUAL

10298: -- Get the details of
10299: CURSOR incl_prd(p_prd_id IN NUMBER)
10300: IS
10301: SELECT 'y' AS include_flag
10302: FROM DUAL
10303: WHERE NOT EXISTS (SELECT NULL
10304: FROM pn_var_rent_inv_all vinv
10305: WHERE vinv.ACTUAL_INVOICED_AMOUNT <> 0
10306: AND vinv.period_id = p_prd_id