818: BEGIN
819:
820: SELECT default_rate_type
821: INTO x_default_rate_type
822: FROM pa_implementations_all
823: WHERE org_id = p_org_id; --MOAC Changes: Bug 4363092: removed nvl usage with org_id
824:
825: EXCEPTION
826: WHEN OTHERS THEN
894:
895: IS
896: CURSOR c1 IS
897: SELECT default_rate_type
898: FROM pa_implementations_all
899: WHERE org_id = p_org_id; --MOAC Changes: Bug 4363092: removed nvl usage with org_id
900:
901: v_c1 c1%ROWTYPE;
902: l_result VARCHAR2(1);