APPS.PN_VARIABLE_AMOUNT_PKG dependencies on DUAL

Line 903: from dual;

899: IF NVL(l_varrent_exists,'N') = 'N' THEN
900:
901: select pn_var_rent_SUMm_s.nextval
902: into l_var_rent_SUMm_id
903: from dual;
904:
905: IF g_rent_TYPE = 'FORECASTED' THEN
906: l_tot_for_vol := p_tot_vol;
907: l_for_var_rent := l_var_rent;

Line 1600: FROM dual

1596: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (+) ');
1597:
1598: SELECT 'Y'
1599: INTO l_varrent_exists
1600: FROM dual
1601: WHERE EXISTS (SELECT null
1602: FROM pn_var_rent_summ_all
1603: WHERE line_item_id = p_line_item_id
1604: AND grp_date_id = p_grp_date_id);

Line 1945: FROM DUAL

1941: IF p_var_rent_type IN ('ADJUSTMENT') THEN
1942:
1943: SELECT 'Y'
1944: INTO l_term_exists
1945: FROM DUAL
1946: WHERE exists ( SELECT null
1947: FROM pn_payment_terms_all
1948: WHERE var_rent_inv_id = p_var_rent_inv_id
1949: AND var_rent_TYPE IN ('ACTUAL', 'VARIANCE'));

Line 1953: FROM DUAL

1949: AND var_rent_TYPE IN ('ACTUAL', 'VARIANCE'));
1950: ELSE
1951: SELECT 'Y'
1952: INTO l_term_exists
1953: FROM DUAL
1954: WHERE exists ( SELECT null
1955: FROM pn_payment_terms_all
1956: WHERE var_rent_inv_id = p_var_rent_inv_id
1957: AND var_rent_TYPE = p_var_rent_TYPE);

Line 1994: FROM dual

1990: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (+) : ');
1991:
1992: SELECT 'Y'
1993: INTO l_volume_exists
1994: FROM dual
1995: WHERE not exists (SELECT null
1996: FROM pn_var_rent_summ_all summ,
1997: (SELECT gd.period_id,
1998: lines.line_item_id,

Line 2040: FROM dual

2036: p_var_rent_TYPE VARCHAR2,
2037: p_var_rent_id NUMBER,
2038: p_period_id NUMBER) IS
2039: SELECT 'Y' term_exists
2040: FROM dual
2041: WHERE EXISTS (SELECT null
2042: FROM pn_var_rent_inv_all inv
2043: WHERE inv.forecasted_exp_code = decode(p_var_rent_TYPE,'FORECASTED','N',inv.forecasted_exp_code)
2044: AND inv.actual_exp_code = decode(p_var_rent_TYPE,'ACTUAL','N',inv.actual_exp_code)

Line 2059: FROM dual

2055: p_var_rent_TYPE VARCHAR2,
2056: p_var_rent_id NUMBER,
2057: p_period_id NUMBER) IS
2058: SELECT 'Y' term_exists
2059: FROM dual
2060: WHERE EXISTS (SELECT null
2061: FROM pn_var_rent_inv_all inv
2062: WHERE inv.actual_exp_code = 'N'
2063: AND inv.forecasted_exp_code = 'N'

Line 2584: FROM dual

2580: /* Cursor to chk if volume history exists for a line_item_id AND grp_date_id */
2581: CURSOR csr_any_vol_exists (ip_line_item_id NUMBER,
2582: ip_grp_date_id NUMBER) IS
2583: SELECT 'Y'
2584: FROM dual
2585: WHERE exists (SELECT null
2586: FROM pn_var_vol_hist_all
2587: WHERE line_item_id = ip_line_item_id
2588: AND grp_date_id = ip_grp_date_id);

Line 2595: FROM dual

2591: CURSOR csr_vol_exists(ip_period_id NUMBER,
2592: ip_invoice_date DATE,
2593: ip_rent_TYPE VARCHAR2) IS
2594: SELECT 'Y'
2595: FROM dual
2596: WHERE exists (SELECT null
2597: FROM pn_var_vol_hist_all vh,
2598: pn_var_grp_dates_all gd
2599: WHERE vh.period_id = gd.period_id