DBA Data[Home] [Help]

APPS.PA_CC_TRANSFER_PRICE dependencies on DUAL

Line 3969: FROM DUAL

3965: ELSE
3966: /* Code Added for Bug#2469987 -- Start */
3967: BEGIN
3968: SELECT 1 INTO l_check_line
3969: FROM DUAL
3970: WHERE EXISTS (
3971: SELECT 1
3972: FROM pa_cust_rev_dist_lines_all
3973: WHERE expenditure_item_id = p_expenditure_item_id(i)

Line 4059: from dual;

4055: END IF;
4056: l_exp_func_curr_code := p_exp_func_curr_code(i);
4057: select decode(p_sys_linkage_function(i),'BTC',6,2)
4058: into l_sl_function
4059: from dual;
4060:
4061: IF p_raw_cost_rate(i) IS NULL THEN
4062: SELECT DECODE(nvl(COST_RATE_FLAG,'N'),'N',1,NULL)
4063: INTO l_raw_cost_rate