DBA Data[Home] [Help]

APPS.QP_PS_ATTR_GRP_PVT dependencies on DUAL

Line 3620: g_automatic_flag_fnl_tbl(i) FROM dual WHERE g_pricing_phase_id_final_tbl(i) <> 1 ;

3616: g_null_other_oprt_cnt_fnl_tbl(i),
3617: g_pte_code_fnl_tbl(i),
3618: g_prc_brk_typ_code_fnl_tbl(i),
3619: g_list_line_typ_code_fnl_tbl(i),
3620: g_automatic_flag_fnl_tbl(i) FROM dual WHERE g_pricing_phase_id_final_tbl(i) <> 1 ;
3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: if g_call_from_setup = 'Y' then
3624: oe_debug_pub.add('PS_ATTR_GRP_PVT.populate_pp_atgrps ' || SQLERRM);

Line 3890: select qp_patterns_s.nextval into l_pattern_id from dual;

3886: -- and pattern_type = p_pattern_type
3887: and rownum = 1;
3888: exception
3889: when no_data_found then
3890: select qp_patterns_s.nextval into l_pattern_id from dual;
3891: l_pattern_to_be_created := 'Y';
3892:
3893: when others then
3894: raise;