50: x_return_status := fnd_api.g_ret_sts_success ;
51:
52:
53: BEGIN 54: SELECT 'Y' into v_temp from dual 55: WHERE exists
56: (SELECT 1 from
57: po_asl_attributes paa,
58: po_approved_supplier_list pasl,
Line 86: select 'Y' INTO v_temp from dual where exists
82: INTO l_sob_id
83: FROM org_organization_definitions OOD
84: WHERE OOD.organization_id = p_organization_id;
85: 86: select 'Y' INTO v_temp from dual where exists 87: (
88: select paa.asl_id
89: from
90: po_vendors pv,
[Home] [Help]