APPS.IEX_COLL_IND dependencies on DUAL

Line 1980: from dual;

1976: begin
1977: select nvl(amount_due_org_ocm(p_party_id,p_cust_account_id,p_customer_site_use_id,p_start_date,p_end_date),0)+
1978: nvl(get_adj_total_ocm(p_party_id,p_cust_account_id,p_customer_site_use_id,p_start_date , p_end_date),0)
1979: into l_tot_sales
1980: from dual;
1981:
1982: l_num_val := ROUND(nvl(l_tot_sales,0), 2);
1983: fnd_file.put_line(FND_FILE.LOG,' COMP_TOT_REC_OCM l_tot_sales '|| l_num_val);
1984: RETURN l_num_val;

Line 2628: FROM dual;*/

2624: SELECT TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
2625: TRUNC(sysdate) pastYearTo
2626: INTO g_curr_rec.past_year_from,
2627: g_curr_rec.past_year_to
2628: FROM dual;*/
2629: NULL;
2630: --End bug#5208170 schekuri 29-May-2006
2631: EXCEPTION
2632: WHEN OTHERS THEN